Print a Specific Area in Excel: Steps, Scaling, and Fixes

How-to basics · Updated November 21, 2026

To print a specific area in Excel for Microsoft 365 on Windows, select the cells, then choose Page Layout > Print Area > Set Print Area. To print a selection just once without saving it as the worksheet’s print area, select the cells, press Ctrl+P, and choose Print Selection in the print settings.

These options keep unrelated cells off the page, but they work differently: a saved print area is reused when you print that worksheet, while Print Selection is a one-time choice. Before sending the job to a printer or PDF, check Print Preview to confirm the selected range fits and the text remains readable.

What a print area does

A print area tells Excel which cells on a worksheet to include when printing. It is a worksheet setting saved with the workbook, not a change to the data itself. Setting one does not hide or delete cells, and it does not prevent you from editing or selecting cells outside the area. It simply limits the worksheet’s printed output.

For example, if a worksheet has a monthly sales table in A1:F25 and notes in H1:J12, setting A1:F25 as the print area excludes the notes when you print that sheet. The print area can include blank cells inside its selected rectangle: if you set A1:F25, Excel prints the whole range, even if some cells are empty. This can be useful for preserving a planned table layout, but it may also leave white space.

Print areas are defined separately for each worksheet. A workbook can therefore have a different print area on each tab. The setting remains in place when the workbook is saved, so a later print job may use it without requiring you to select the cells again.

Set a print area on Windows

Use the ribbon to define a reusable print area in Excel for Microsoft 365 on Windows:

  1. Open the worksheet and select the range you want to print. Drag across the cells, or click the first cell, hold Shift, and click the last cell in the range.
  2. Choose Page Layout > Print Area > Set Print Area.
  3. Press Ctrl+P or choose File > Print to open the print screen.
  4. Review the preview on the right. Confirm the correct worksheet, printer, page count, and layout before printing.

The selected range becomes the print area for that worksheet. If the preview shows only the intended content, choose Print. If the range spans several pages, Excel can still print it; setting a print area does not automatically make the content fit on one page.

To define a range precisely, you can also select cells using the Name Box to the left of the formula bar. For instance, type A1:F25 in the Name Box and press Enter, then use the Set Print Area command. This can be easier than dragging through a large worksheet, and it avoids accidentally including an adjacent column.

Print a selection once

If you only need a temporary printout, use Print Selection rather than changing the worksheet’s saved print area. Select the cells, press Ctrl+P, and open the print-settings dropdown that normally says Print Active Sheets. Choose Print Selection, check the preview, and print. This choice applies to the current print job; it does not replace the worksheet’s existing print area.

Use this approach for an occasional excerpt, such as a few rows from a longer inventory list, or when you do not want to alter how the sheet is normally printed. Be careful to make the selection before opening the print screen. If you select the wrong cells, return to the worksheet, correct the selection, and reopen Print.

A temporary selection and a saved print area are not interchangeable in every situation. For a recurring report, a saved print area is more convenient. For a one-off extract, Print Selection is usually simpler. Either way, the preview is the quickest way to catch a mistaken range before printing.

Add to, change, or clear the print area

Excel lets you expand an existing print area without replacing it. Select another range, then choose Page Layout > Print Area > Add to Print Area. The original and added ranges are treated as separate print areas. Excel may print separate areas on separate pages, so check the preview rather than assuming that separated blocks will be joined into one continuous table.

To replace the current area, select the new range and choose Set Print Area. This sets the selection as the print area, replacing the previous definition on that worksheet. To remove the saved setting, choose Page Layout > Print Area > Clear Print Area. With the print area cleared, Excel can print the sheet’s used content according to the print settings and page layout.

Clearing the print area does not erase cells, formatting, or data. It removes the restriction on what part of the worksheet is designated for printing. If the next preview includes far more cells than expected, check whether the sheet has formatting or content far from the main table and set a new area if appropriate.

Fit the area to pages without shrinking it too far

A print area can cover more than one printed page. If you want a wide report to fit across the page, use the scaling controls rather than deleting columns or reducing the font immediately. In the print screen, use the scaling options under Settings, such as Fit All Columns on One Page. This can keep every column together while allowing rows to continue onto additional pages.

Fit Sheet on One Page scales both the width and height to one page. It is convenient for a small table, but a large range may become too small to read. Fit All Columns on One Page is often a better starting point for a wide table, while Fit All Rows on One Page may help with a short, wide selection. Choose No Scaling when preserving the worksheet’s print size matters more than reducing the page count.

You can also adjust orientation and paper size. Choose Page Layout > Orientation > Landscape for a report with many columns, or keep Portrait for a tall, narrow list. Page Layout > Size lets you select a paper size supported by the printer. Margins can be changed from Page Layout > Margins. These adjustments affect the layout, but they do not change which cells are in the print area.

For more direct control, inspect the Scale to Fit settings on the Page Layout tab. Setting Width to 1 page constrains the printout to one page across; leaving Height automatic allows it to span multiple pages vertically. Avoid forcing both Width and Height to one page for a large report unless you have confirmed the resulting text is legible.

Use page breaks and repeating headings

When a print area spans multiple pages, decide where a page should break. Choose View > Page Break Preview to see page boundaries and, where available, drag a page-break line to adjust the division. Return to Normal view when finished. A page break changes how the range is divided; it does not change the print area itself.

If a table has column headings at the top, you may want them repeated on every printed page. Choose Page Layout > Print Titles, then specify rows to repeat at top or columns to repeat at left in the Page Setup dialog. This is different from setting a print area: the print area chooses the cells to print, while print titles repeat selected headings across the pages of a multi-page printout.

Check the preview after changing breaks or print titles. A heading row that repeats can take up space on every page, and a manually adjusted break can create an extra page. Preview makes it easier to see whether the report reads naturally from one page to the next.

Common problems and their fixes

  • The preview still shows the whole worksheet: Confirm that you are printing the intended worksheet and that the area was set on that sheet. If you used Print Selection, select the cells first and choose Print Selection in the print settings.
  • Some columns or rows are missing: Check the range boundaries and look for hidden rows or columns. If the print area is too narrow, set it again with the additional cells included.
  • The table is split awkwardly: Change orientation, margins, scaling, or page breaks. For a wide list, try Landscape and Fit All Columns on One Page, then check that the text is still readable.
  • The printout contains an unexpected blank page: Inspect the selected area, page breaks, scaling, and any extra print areas. A large blank region inside the selected range can affect pagination even though it contains no values.
  • Changes do not appear in the preview: Return to the worksheet and confirm the print area or selection, then reopen the print screen. Also verify that the active sheet is the one you intended to print.

Formatting can influence how a worksheet is laid out, but a print area is based on cell ranges, not simply on which cells look populated. If a stray formatted cell far away makes the worksheet appear to have a large used area after clearing the print area, select only the actual report range and set it again.

Print multiple worksheets or save as PDF

For a workbook with several tabs, check which sheets are included in the print job. Excel can print the active sheet, selected sheets, or the entire workbook, depending on the option chosen in the print screen. A print area on one worksheet does not automatically define the print area on every other worksheet. Review the preview and page count before printing a group of sheets.

To create a digital copy instead of using paper, choose File > Print and select a PDF printer or PDF output option available on your computer. The exact printer name depends on the system and installed software. The same print-area and scaling choices apply: preview the pages and check the saved PDF, especially when the output includes several worksheets or multiple pages.

For a recurring report, save the workbook after setting the print area and page layout. That preserves the worksheet’s print setup for later use. A PDF is useful when you need to share a fixed version of the printout, while the workbook remains editable and retains the underlying cells.

Excel on Mac and Excel for the web

In Excel for Microsoft 365 on Mac, select the cells and use Page Layout > Print Area > Set Print Area; the ribbon wording is generally similar to Windows. To print, use Command+P rather than Ctrl+P. Keyboard shortcuts differ between operating systems, but the saved print-area concept is the same.

Excel for the web has a different interface and can change over time. Select the cells and inspect File > Print for the available selection and sheet-printing choices. If you need the full desktop ribbon controls for saved print areas, print titles, or detailed page setup, open the workbook in the Excel desktop app and verify the print preview there. Web printing can also depend on the browser’s print dialog and available printer settings.

Frequently Asked Questions

How do I print only selected cells in Excel?
Select the cells, press Ctrl+P on Windows, and choose Print Selection in the print settings. Check the preview to confirm that only the intended selection is included.

How do I set a permanent print area in Excel?
Select the range and choose Page Layout > Print Area > Set Print Area. The setting applies to that worksheet and is saved with the workbook.

How do I remove a print area?
On the relevant worksheet, choose Page Layout > Print Area > Clear Print Area. This removes the print restriction but does not delete worksheet content.

Can I print a range on one page?
Yes. In the print settings, try Fit Sheet on One Page, or use Page Layout scaling controls. For a large range, fitting everything on one page may make the text too small, so check the preview.

Why does Excel print a blank page?
A selected range may include empty cells, or page breaks, scaling, or multiple print areas may be adding a page. Inspect the preview and adjust the range or layout settings.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.