Excel Print Area: Set, Adjust, and Troubleshoot

In Excel for Microsoft 365 on Windows, select the cells you want to print, then choose Page Layout > Print Area > Set Print Area. The print area tells Excel which part of a worksheet to include when you print; you can review the result with File > Print.

What an Excel print area does

A print area is a defined range of worksheet cells that Excel uses as the printable content for that sheet. It is useful when a worksheet contains working notes, source data, or calculations that should remain in the file but should not appear on paper or in a PDF. For example, a monthly report might use columns A through F for its presentation while columns G through J contain supporting calculations. Setting A1:F35 as the print area keeps those extra columns out of the printed report.

A print area is not the same as hiding rows or columns. Hidden content remains hidden in the worksheet, while a print area simply limits what is sent to print; cells outside it remain visible and editable on screen. Nor does a print area decide how the chosen cells are divided among pages. Paper size, orientation, margins, scaling, and page breaks affect that layout.

Excel saves the print area with the worksheet in the workbook. Each worksheet can have its own print area, so a workbook with several report tabs may need separate print settings for each one. The setting does not change the underlying cell values or formulas.

How to set, change, or clear a print area

Select the cells to include. Drag across a continuous range, or use the Name Box to select a range such as A1:F35.
Open the Page Layout tab.
In the Page Setup group, select Print Area > Set Print Area.
Choose File > Print to check the preview before printing or saving as a PDF.

Setting a new print area replaces the current print area on that worksheet. To include another separate range without replacing the first one, select the additional cells and choose Page Layout > Print Area > Add to Print Area. To remove the defined area, choose Page Layout > Print Area > Clear Print Area. Clearing it does not delete cells; it removes the limit so Excel can use its normal print range for the sheet.

If the ribbon is narrow, some commands may appear in a condensed menu, but the Print Area command remains on the Page Layout tab. On Excel for Mac, use the Page Layout tab and its Print Area menu as well. The print preview shortcut is Ctrl+P on Windows and Command+P on Mac.

Using more than one print range

A print area can contain multiple nonadjacent selections. To create one, select the first range, hold Ctrl while selecting additional ranges, then use Page Layout > Print Area > Set Print Area. On Mac, hold Command while selecting the separate ranges. You can also add a range to an existing print area through Add to Print Area.

Separate areas are not automatically joined into one continuous block. Excel treats them as separate print areas, which can affect page order and layout; each area may print on its own page or pages. For instance, printing A1:C20 and E1:G20 this way can produce separate sections rather than a single report with the gap removed. If the intended result is one compact table, copying the required columns together on a report sheet is often clearer than relying on nonadjacent areas.

Check the preview after adding ranges. A selection that includes many blank rows or columns can create extra pages, and multiple areas can make the output less predictable than one rectangular range. If the printout should have a particular reading order, a dedicated summary sheet is usually easier to format and maintain.

Fit the print area to paper

After deciding what to print, decide how it should fit on the page. In the Page Layout tab, set Orientation to Portrait or Landscape, choose a Size such as Letter or A4, and adjust Margins. The correct choices depend on the report and the paper available. A wide table may be easier to read in landscape orientation, while a narrow list may suit portrait.

Excel also provides scaling controls. In the Page Layout tab’s Scale to Fit group, set the width or height to a page count. For example, setting width to one page and leaving height automatic can keep all columns together while allowing rows to continue onto additional pages. Setting both width and height to one page forces the entire area onto a single sheet of paper, but can shrink text until it is difficult to read.

The Print screen offers related scaling choices, such as fitting all columns on one page or fitting the sheet on one page. Use these options deliberately: fitting all columns can be helpful for a wide report, but it may reduce the font size. If the preview looks cramped, consider landscape orientation, narrower margins, a larger paper size, or a more compact print area before scaling everything down.

For multi-page reports, repeated headings can make later pages understandable. Use Page Layout > Print Titles to specify rows to repeat at the top or columns to repeat at the left of printed pages. Print titles are separate from the print area: the print area identifies the cells to print, while print titles repeat selected headings across pages.

Check page breaks and print preview

Use File > Print to see a page-by-page preview, select a printer, and review the selected scaling option. The preview can reveal clipped columns, an unexpectedly small report, blank pages, or content split across pages. You can move between pages in the preview to inspect the whole output rather than judging it from the first page alone.

For more direct control over page divisions, choose View > Page Break Preview. This view displays the worksheet’s print pages and page-break boundaries. You can adjust page breaks when the split is awkward, but a manual page break is different from a print area: it changes where pages divide, not which cells are included. Return to Normal view when finished editing the layout.

A dotted line on the sheet often indicates a page break, not necessarily the edge of the print area. If the print preview still includes unexpected cells, check the selected print setting and the defined area rather than assuming the dotted line marks the printable range. Preview again after changing print settings, since a change to paper size or scaling can alter page breaks.

Print area, print selection, and worksheet printing

Excel’s print choices can override or differ from the saved print area. Under File > Print, the Settings menu typically lets you print active sheets, the entire workbook, or a selection. Print Selection is useful for a one-time print of highlighted cells, but it is not the same as setting a print area for future printing. If you expect the saved print area to be used, check that the setting is not instead set to Print Selection.

Print Active Sheets prints the selected worksheet or worksheets, using their print settings. Print Entire Workbook includes all worksheets, so review every sheet that should be included. A print area on one sheet does not automatically create or define print areas on the other sheets. For a workbook with several tabs, check the preview and settings for each relevant sheet before distributing the output.

Saving a workbook as a PDF through Excel’s print workflow generally uses the same page layout and print settings as a paper print. That makes previewing worthwhile even if no physical printer is involved. If a PDF has an unexpected page count, revisit the print area, scaling, and page breaks.

Common print-area problems

Extra blank pages: The selected range may include empty rows or columns, or a page break may push content onto another page. Clear the print area and set a tighter range, then inspect Page Break Preview.
Missing content: The content may lie outside the defined range, or File > Print may be set to Print Selection. Extend the area or choose the intended print setting.
Text is too small: Fitting both width and height to one page can shrink a large range substantially. Let the report use multiple pages, or reduce its width and adjust orientation or margins.
Only one part of a report prints: A new Set Print Area command may have replaced the previous range. Use Add to Print Area for an extra selection, or set one larger rectangular range.
Unexpected pages after editing: Added rows or columns are not always included in an existing defined area. Update the area and check the preview after changing the report structure.

When a range keeps changing, one practical approach is to set the print area after the report is complete and then verify it again after inserting rows or columns. For a reusable template, leave a small note outside the printed range explaining which cells are intended for the report, or keep the print-ready content on a separate worksheet. That reduces the chance that working data will appear in a client-facing document.

Frequently Asked Questions

How do I see the print area in Excel?
Choose File > Print to see the printable pages in preview. For page boundaries on the worksheet itself, choose View > Page Break Preview. The preview is the best way to confirm exactly what will be printed.

How do I remove a print area in Excel?
On the worksheet, choose Page Layout > Print Area > Clear Print Area. This removes the print-area definition but does not remove or alter worksheet data.

Can I print only selected cells without saving a print area?
Yes. Select the cells, open File > Print, and choose Print Selection in the Settings menu. This is convenient for a one-time print; use Set Print Area when you want a persistent range for that worksheet.

Does a print area affect what I see in the worksheet?
No. It affects printing, not the worksheet’s on-screen content. Cells outside the print area remain visible and editable unless you separately hide them or apply another worksheet change.

Why is my Excel print area printing on several pages?
A print area defines the content, not a one-page guarantee. Paper size, orientation, margins, scaling, and page breaks determine how many pages it occupies. Check File > Print, and use the Scale to Fit controls only if the resulting text remains readable.

Can I set a print area in Excel for the web?
Excel for the web has printing options, but its page-layout controls may differ from the Windows desktop app. For a complex layout or a workbook that depends on a saved print area, open it in desktop Excel and confirm the result in Print Preview.

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.