Excel Adjusting Print Area: Fit, Set, and Clear Pages

How-to basics · Updated November 18, 2026

To adjust a print area in Excel for Microsoft 365 on Windows, select the cells you want, then choose Page Layout > Print Area > Set Print Area. To change it, select a different range and set it again; to remove the saved boundary, choose Page Layout > Print Area > Clear Print Area. Check the result with File > Print before sending the sheet to a printer.

What a print area controls

A print area is the part of a worksheet Excel includes when you print that sheet. It is useful when a worksheet contains supporting calculations, notes, or other material that should remain in the workbook but not appear on paper. Setting an area does not delete, hide, or protect cells; it only defines the print boundary.

Without a defined print area, Excel generally prints the worksheet’s used content, subject to the print settings and page layout. A print area can limit that output to a specific range, such as A1:F28 for a small report. It does not, by itself, determine how that range fits on paper. Page orientation, paper size, margins, scaling, and page breaks also affect the printed result.

Set or replace the print area

First select the cells to include. You can drag across the range, or click the Name Box to the left of the formula bar, type a reference such as A1:F28, and press Enter. Then use Page Layout > Print Area > Set Print Area. Excel marks the selected range as the print area for that worksheet.

Setting a new print area replaces the existing print area for the sheet. For example, if the current area is A1:H40 and you set B2:F25, Excel will use B2:F25 instead of the former boundary. Selection mistakes are easy to correct: select the intended range and set the area again. You do not need to clear the old area first.

To confirm what Excel will print, use File > Print to open Print preview. The preview is especially important when the sheet has unusual formatting, merged cells, or manually inserted page breaks. On Windows, Ctrl+P opens the print screen; on a Mac, use Command+P. The ribbon path for setting the print area is broadly similar in current desktop Excel for Mac, although the ribbon layout can vary by release.

Add separate ranges to one print area

A worksheet can have more than one print-area range. This helps when the information to print is in separate blocks, such as a summary at the top and a small reference table farther down the sheet. Select the first range and set it as the print area. Then select another range and choose Page Layout > Print Area > Add to Print Area.

Excel prints separate areas as separate print sections, generally beginning each area on a new page. The order and pagination can be less intuitive than printing one continuous rectangle, so inspect the preview. If the blocks should sit together on the same page, it may be simpler to copy them into a temporary report sheet or arrange them in adjacent columns before setting one rectangular print area.

  • Use Set Print Area when creating a new boundary or replacing the current one.
  • Use Add to Print Area when the new selection should be another separate block in the existing print area.
  • Use Clear Print Area to remove the saved print-area definition from the worksheet.

Fit the area to paper without shrinking it too far

Setting the print area chooses what to print; scaling chooses its size on the page. If a report is only slightly too wide, switch to landscape orientation or adjust the margins before shrinking the entire sheet. On the Page Layout tab, use Orientation to choose Portrait or Landscape, and Margins to choose a preset or open Custom Margins. Paper Size should match the paper loaded in the printer or the paper size selected in the print dialog.

For more direct control, Page Layout > Scale to Fit provides Width and Height settings. Setting Width to 1 page tells Excel to fit the print area across one page horizontally. Leaving Height set to Automatic allows the content to continue onto multiple pages vertically. Setting both Width and Height to 1 page forces the entire area onto one sheet of paper, which can make text and figures too small to read.

Another route is File > Print, where the scaling options include choices such as Fit Sheet on One Page and Fit All Columns on One Page. The exact wording or placement may differ slightly with the printer and Excel release. For a wide table with many rows, fitting all columns on one page is often more readable than compressing both dimensions onto a single page. Check the preview and, if necessary, use a larger paper size or split the report into sensible sections.

Use page breaks to control pagination

Even with a print area defined, Excel may divide it across pages according to the available space, scaling, and page setup. To see the page divisions in the worksheet, choose View > Page Break Preview. Blue lines show page boundaries; in supported desktop versions, you can drag a boundary to change where a page ends. Return to View > Normal when you have finished adjusting the layout.

To insert a deliberate break, select the row below where a horizontal break should go, or the column to the right of a vertical break, and choose Page Layout > Breaks > Insert Page Break. A manual break can help keep a heading with its table or separate a report by department. If the page setup or scaling changes later, review the breaks again because a layout change can alter how the sheet paginates.

Page breaks and print areas solve different problems. The print area excludes cells outside the chosen boundary; page breaks divide the included cells among pages. Neither setting changes the data or the way the worksheet looks during ordinary editing.

Repeat headings and improve readability

When a print area spans several pages, column headings may appear only on the first page unless you tell Excel to repeat them. Choose Page Layout > Print Titles. In the Page Setup dialog, enter the rows to repeat at the top or columns to repeat at the left, then confirm the settings. For example, if the header is in row 1, set Rows to repeat at top to $1:$1. Repeating headings makes multi-page tables easier to interpret.

Also check that important content is not cut off at a page boundary. Long labels can wrap, and row heights may need adjustment. If a column is too wide, consider wrapping its text, reducing unnecessary column width, or using landscape orientation rather than immediately scaling the whole report down. Print preview can reveal clipped text, unexpected blank pages, and pages containing only a narrow strip of columns.

Clear, inspect, and save print settings

Choose Page Layout > Print Area > Clear Print Area to remove the print-area definition from the active worksheet. Clearing it does not erase cells, formatting, page breaks, or print-title settings. It removes the boundary that restricted what the sheet printed, so Excel can again use the worksheet’s printable content. If the workbook has several sheets, a print area set on one sheet does not automatically clear the others.

Print-area settings are stored with the workbook. Save the file after making changes if you want the layout to remain when the workbook is reopened. If the boundary seems to disappear, verify that you are on the intended worksheet and that you saved the correct workbook. If a coworker receives the file, they can inspect the same sheet’s print preview, though their printer’s paper settings may affect pagination.

Excel for the web is useful for viewing and editing a workbook, but its printing controls may not offer the same saved print-area workflow as desktop Excel. When a persistent print area is needed, open the workbook in the desktop app and set it there. In the web app, printing a selected range may be available through the print flow, but that is not necessarily the same as saving a worksheet print-area definition for future prints.

Common problems and practical fixes

  • Only part of the report prints: The saved print area may be smaller than the content you expect. Select the complete range and choose Set Print Area again, then inspect the preview.
  • Blank pages appear: Check for extra print-area ranges, distant cells with formatting, manual page breaks, or scaling and paper-size mismatches. Page Break Preview can help locate unexpected divisions.
  • The text is tiny: Excel may be fitting both width and height to one page. Try fitting only the width, changing to landscape, or allowing additional pages vertically.
  • A newly added row is missing: A fixed print area does not always expand to include later additions. Reset the area to cover the expanded range or add the new range with Add to Print Area.
  • The preview differs from the printed page: Confirm the selected printer, paper size, and orientation in the print screen. Printer drivers and available paper sizes can change pagination.

One common misconception is that selecting a range before opening Print preview permanently changes the worksheet’s print area. A selection can be used for a one-time print choice in some print workflows, but to save a reusable boundary in desktop Excel, use Page Layout > Print Area > Set Print Area. Another misconception is that clearing a print area removes content: it only removes the printing boundary.

Frequently Asked Questions

How do I adjust the print area in Excel?
Select the cells you want, then choose Page Layout > Print Area > Set Print Area. If you want to keep the current range and include a separate block, use Add to Print Area instead.

How do I remove the print area in Excel?
On the worksheet with the saved boundary, choose Page Layout > Print Area > Clear Print Area. This removes the print-area setting, not the worksheet’s cells or formatting.

How do I print an Excel sheet on one page?
Open File > Print and choose Fit Sheet on One Page, or set Width and Height to 1 page under Page Layout > Scale to Fit. Check readability in preview; fitting a large worksheet to one page can make the text very small.

Why does Excel print blank pages?
Blank pages can result from extra print-area ranges, manual page breaks, a mismatched paper size, or content that extends farther than expected. Check the print preview and Page Break Preview, and clear or reset the print area if needed.

Does Excel save the print area?
Yes. A print area is a worksheet setting saved with the workbook. Save the workbook after changing it, and remember that each worksheet can have its own print area.

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.