Edit Print Area in Excel: Steps, Tips, and Common Fixes

How-to basics · Updated November 18, 2026

To edit a print area in Excel for Microsoft 365 on Windows, select the cells you want to print, then choose Page Layout > Print Area > Set Print Area. To change an existing area, set a new one or use Page Layout > Print Area > Clear Print Area and define it again; check the result in Print Preview before printing.

What a print area does

A print area is a saved cell range, or set of ranges, that tells Excel which part of a worksheet to include when printing. It is useful when a sheet contains working notes, calculations, reference lists, or other material that should remain in the workbook but not appear on paper. For example, if a monthly report occupies A1:F28 and supporting calculations continue in columns H through K, setting A1:F28 as the print area keeps those calculations out of the report.

The print area applies to an individual worksheet, not the whole workbook. Each worksheet can have its own print area, and a sheet without one usually prints its used cells according to the current print settings. The saved area is part of the workbook, so other people opening the file in desktop Excel can use it too. It does not delete or hide cells: it only affects what Excel includes in a print job.

Set or replace the print area

Use the following steps in Excel for Microsoft 365 on Windows:

  1. Open the worksheet and select the cells to print. You can drag across a range, or click the first cell, hold Shift, and click the last cell.
  2. Open the Page Layout tab.
  3. Select Print Area in the Page Setup group, then choose Set Print Area.
  4. Press Ctrl+P to open the print screen and inspect the preview. If it looks right, choose the printer and print settings you need.

Setting a new print area replaces the existing print area on that sheet. You generally do not need to clear the old range first. If the new selection is wrong, select the correct cells and choose Set Print Area again. This is different from simply selecting cells and printing: the saved print area stays in the workbook for later print jobs.

On Excel for Mac, select the cells and use Page Layout > Print Area > Set Print Area where those commands are available in the ribbon. Use Command+P to open printing. Ribbon placement can vary with the window size and Excel build, so maximize the window if the Page Layout commands are not visible. Excel for the web has more limited page-layout controls; use the desktop app to create or edit a saved print area if the command is unavailable online.

Add ranges or print selected cells

A print area can contain more than one range. To add another block without replacing the first, select the additional cells and choose Page Layout > Print Area > Add to Print Area. For example, a summary in A1:D12 and a separate notes block in A20:D25 can be included together while leaving rows 13 through 19 out of the print area.

Separate print-area ranges do not necessarily sit together as one continuous table on a printed page. Excel treats separate areas as distinct sections for printing, and they may print on separate pages. Review the preview to see how the current page setup lays them out. If the sections need to appear as one continuous report, consider placing them next to each other or copying the relevant information into a report sheet instead.

For a one-time print, you can select cells and choose File > Print, then select Print Selection in the print settings if that option is shown. This is different from saving a print area: Print Selection applies to the current print job, while Set Print Area stores the range with the worksheet. The exact print-screen choices can differ by printer and Excel version.

Clear or remove a print area

To remove the saved print area from the current worksheet, choose Page Layout > Print Area > Clear Print Area. Clearing the area does not erase cell contents, change formulas, or remove formatting. It simply returns printing to Excel’s normal range selection for that sheet. If you want to remove an extra section but keep another part of a multi-range print area, the simplest reliable approach is to select the range or ranges you want to retain and choose Set Print Area again.

Print areas are worksheet-specific. Clearing the area on a summary sheet does not clear one on a detail sheet. If a workbook has several tabs, check each relevant sheet before printing. A print area can also remain in a workbook even when the cells are outside the currently visible screen, so a small-looking selection on screen does not by itself prove that no saved area exists.

Check the print preview and page layout

After setting the area, use File > Print or Ctrl+P on Windows to inspect the preview. On Mac, use Command+P. The preview shows how the selected range interacts with paper size, orientation, margins, scaling, and printer settings. A correct print area can still produce an awkward result if the columns are too wide or the content spans many pages.

Use the Page Layout tab to adjust options such as orientation, paper size, and margins. If a report is nearly one page wide but continues onto extra pages, changing orientation to Landscape or choosing a fit-to-page scaling option may help. Be cautious about shrinking an entire large worksheet to one page: the print area may technically fit, but the text can become too small to read. Preview is the place to judge readability, not just page count.

For more control, open the Page Setup dialog from the small dialog-box launcher in the Page Setup group on the Page Layout tab. Depending on the workbook and Excel build, its tabs provide additional settings, including scaling and options for repeating rows or columns. Repeating a header row is not the same as expanding the print area: it repeats the chosen heading on printed pages while the print area still determines which cells are included.

Common print-area problems and fixes

  • Old or unexpected cells still print: Check the saved area with Page Layout > Print Area. Set the intended range again, or clear the print area and create a fresh one. Also check whether another worksheet is being printed.
  • New rows are missing: A saved print area does not automatically include every cell added outside its defined range. Extend the selection and set the area again, especially after adding rows to a report.
  • The preview has extra pages: Look for extra columns, rows, or separate ranges in the print area. Then check page breaks, margins, orientation, and scaling. A selection that is wider than the paper can spill onto additional pages.
  • Blank pages appear: Inspect the print area for stray cells or separate sections far from the main table. Also review page breaks and scaling in preview; formatting or content extending beyond the visible report can affect pagination.
  • Text is cut off: A print area controls which cells are included, not whether their contents fit. Widen columns, adjust row heights, use Landscape orientation, or change scaling and margins, then preview again.
  • The print-area command is unavailable: Confirm that a worksheet is active and that you are using desktop Excel. Some controls differ in Excel for the web, so open the workbook in the desktop app to manage the saved area.

When diagnosing a problem, change one setting at a time and return to preview. This makes it easier to identify whether the cause is the range, page setup, or printer. If a workbook was sent by someone else, do not assume that the visible data is the only content that will print; inspect the print preview before sending it to a shared or public printer.

Print area versus hiding cells or changing the view

A print area is often confused with hiding rows or columns, using Page Break Preview, or changing the worksheet zoom. These features have different purposes. A print area controls the cells included in a print job. Hiding rows or columns changes what is displayed and can also affect what is printed. Page Break Preview helps you see and adjust pagination, while zoom changes how large the sheet appears on screen.

For instance, if you only want a short section on paper but need all rows visible to coworkers in the workbook, use a print area rather than hiding the other rows. If a column should be omitted from both the normal view and printing, hiding it may make more sense. If the report prints across too many pages, page-break and scaling settings are more relevant than changing the print area alone.

Frequently Asked Questions

How do I change the print area in Excel?
Select the cells you want, then choose Page Layout > Print Area > Set Print Area. The new selection replaces the saved print area for that worksheet. Review it in File > Print before printing.

How do I print only selected cells without saving a print area?
Select the cells, open File > Print, and choose Print Selection if it appears in the print settings. This affects that print job only; it does not create a saved print area for future use.

Why does Excel print only part of my spreadsheet?
A saved print area may exclude the rest of the sheet. On the relevant worksheet, choose Page Layout > Print Area > Clear Print Area to remove it, or set a larger area that includes the missing cells.

Will a print area automatically include rows I add later?
Not if the new rows fall outside the saved range. Extend the print area after adding content and check the preview. This is especially important when a report grows from month to month.

Can I set different print areas on different worksheets?
Yes. Each worksheet can have its own print area. Select the sheet, define its range, and repeat for any other sheet you intend to print; clearing or changing one sheet’s area does not automatically change the others.

Does a print area change or delete data?
No. It only determines what Excel includes when printing. The cells remain in the worksheet and can still be viewed, edited, and used in formulas.

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.