Excel Print Area: Set It, Clear It, and Print Automatically

How-to basics · Updated November 21, 2026

No—Excel does not automatically expand a worksheet’s print area when you add data; a print area is a saved range that stays fixed until you change it. You can update it manually, choose a different range when printing, or use a macro to keep it aligned with a table.

What an Excel print area does

A print area tells Excel which cells on a worksheet to include when you print. It is useful when a sheet contains working notes, lookup lists, or calculations that should stay on screen but not appear on the printed page. For example, if a monthly report occupies A1:F28 and helper calculations sit in H1:J28, setting A1:F28 as the print area keeps those helper cells out of the report.

The print area controls the boundary of the content, not how that content fits on paper. Orientation, margins, scaling, and page breaks affect the layout inside that boundary. A print area also does not send a document to the printer by itself: it only defines what Excel considers printable when you print the sheet.

When no print area has been set, Excel normally prints the worksheet’s used cells rather than every empty cell in the grid. That can still include stray content or formatting far beyond the intended report, which is one reason an explicit print area can help.

Why it does not expand automatically

In Excel for Microsoft 365 on Windows, a print area is stored as a range reference for that worksheet. If you set it to A1:F28 and later enter new records in rows 29 and 30, the saved boundary does not automatically become A1:F30. The new records may remain outside the print area, even though they are visible in the worksheet.

This behavior is intentional: Excel cannot know whether added cells belong in the printed report or are notes, calculations, or unrelated content. A fixed boundary gives predictable results for a form or a report with a designed layout. For a growing list, however, you need to revise the boundary or use a process that updates it.

One common misconception is that converting a range to an Excel Table automatically makes the print area dynamic. A table can expand as rows are added, but an already-defined print area is still its own setting. A table is a helpful foundation for automation, not a guarantee that the print boundary will follow it.

Set, change, or clear the print area

To set a print area in desktop Excel for Windows, select the cells you want on the page, then choose Page Layout > Print Area > Set Print Area. Excel saves that range for the current worksheet. You can then use File > Print to review the preview before printing.

To replace the existing boundary, select the new cells and choose Page Layout > Print Area > Set Print Area again. To remove the boundary completely, choose Page Layout > Print Area > Clear Print Area. After clearing it, Excel returns to printing the worksheet’s used cells unless you choose a print selection or set another print area.

  1. Open the worksheet you want to print and select the intended cells.
  2. Choose Page Layout > Print Area > Set Print Area.
  3. Open File > Print and inspect the preview, including all pages.
  4. If the preview is wrong, return to the sheet, revise or clear the print area, and check again.

On Mac, the corresponding command is available from the Page Layout tab under Print Area; ribbon wording and arrangement can vary slightly by Excel release. The print preview is available through File > Print, and Command+P opens the print screen. In Windows, use Ctrl+P.

Choose a print area or print a one-time selection

A saved print area is best when you repeatedly print the same part of a worksheet. If you only need a subset once, you may not want to change the worksheet’s saved settings. Select the cells, open File > Print, and choose Print Selection in the print settings. This prints the selected cells for that print job rather than establishing a permanent boundary.

Use a saved print area when a recurring report should always exclude the same columns or notes. Use Print Selection for an ad hoc extract, such as printing two columns of a larger worksheet for a quick meeting. Check the preview either way: an unintended selection or an extra page can be easy to miss.

You can also set more than one print area on a worksheet by selecting nonadjacent ranges while holding Ctrl on Windows and then setting the print area. Excel treats separate areas as separate print regions, which can affect page order and page count. This is handy for distinct blocks, but if you need a single continuous report, a contiguous range is usually easier to manage.

Fit the print area to paper

A correct print area can still produce an awkward printout. A wide report may spill onto several pages horizontally, or a large selection may shrink until its text is difficult to read. Use the print preview to check the number of pages, the placement of page breaks, and whether the content is legible.

For a wide sheet, try Page Layout > Orientation > Landscape. To adjust how much fits on a page, use the Scale to Fit controls on the Page Layout tab, or choose a scaling option in the print settings. “Fit all columns on one page” can be useful for a wide report, but it may make small text too tiny; fitting a few columns across pages can be more readable.

Margins and page breaks also matter. Narrower margins can make room for a little more content, while Page Layout > Breaks lets you manage page breaks. If a report repeats column headings on later pages, use Page Layout > Print Titles to set rows or columns to repeat. Print titles are separate from the print area: they repeat labels but do not expand the range being printed.

Make a growing table print automatically with VBA

If the print boundary should track a table as it grows, a worksheet-change macro can reset the print area to the table’s current range. First format the data as a table with Insert > Table or Home > Format as Table, and give it the name SalesTable using the Table Design tab. The example below updates the active worksheet’s print area to that table whenever a cell on the sheet is edited.

Place this event procedure in the worksheet’s code module, not in a standard module: right-click the worksheet tab, choose View Code, and paste the code there. Change the table name in the code if your table has a different name.

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim salesTable As ListObject

    ' Keep the print area aligned with this worksheet's table.
    Set salesTable = Me.ListObjects("SalesTable")
    Me.PageSetup.PrintArea = salesTable.Range.Address
End Sub

This is an option for desktop Excel, not a setting that turns on automatically in every workbook. Save a macro-enabled copy as an .xlsm file and enable macros only when you trust the workbook. Make a backup before running a macro: macro actions cannot be undone with Ctrl+Z. The procedure runs after a cell edit; a formula recalculating because a different cell changed may not trigger a change event on the sheet containing the formula. Excel for the web does not run VBA macros.

Common print-area problems

  • New rows are missing: The saved print area still ends at the old last row. Extend the range, reset it, or use a suitable automation method.
  • A blank page appears: Check for stray content, formatting, or an extra print area outside the intended report. Clear the print area and set it again if necessary.
  • The report is split unexpectedly: Review page breaks, paper size, orientation, and scaling in the print preview. The range can be right while the page layout is not.
  • Headings appear only on page one: Set repeating rows through Page Layout > Print Titles; adding those rows to the print area alone will not repeat them on later pages.
  • The printout includes old cells: Clear the print area and inspect the selected cells before setting a new one. Also check whether the sheet has multiple print regions.

If a preview looks different from what you expect, check whether Excel is set to print the active sheet, the entire workbook, or a selection. The print screen’s settings determine the scope of that job, while the saved print area is a worksheet-level boundary. These controls work together but are not interchangeable.

Excel for the web and other alternatives

Excel for the web has different page-layout and printing capabilities from desktop Excel. Its print experience can let you print a selected range, but it does not provide the same VBA automation as desktop Excel. If a workbook depends on a saved print area or a macro-driven workflow, open it in desktop Excel to manage those settings reliably, then inspect the print preview there.

For an occasional printout, selecting cells and choosing Print Selection avoids maintaining a saved area. For a recurring report that grows, a table plus a desktop macro can keep the range current, provided macros are permitted. For a fixed form, a manually set print area is simpler and often safer than automation. The right choice depends on whether the content boundary is stable, changes occasionally, or grows with incoming records.

Frequently Asked Questions

Does an Excel Table automatically update the print area?
No. A table can expand when you add rows, but a print area set earlier does not necessarily expand with it. Reset the print area or use an appropriate macro if it must follow the table.

How do I print only selected cells without changing the print area?
Select the cells, open File > Print, and choose Print Selection from the print settings. Review the preview before printing.

Why does Excel print a blank page after my report?
A print area may include extra cells, the worksheet may contain stray content or formatting, or page breaks may push content onto another page. Review the preview and reset the print area to the intended range.

Will the print area change when a formula returns more rows?
Not by itself. A formula’s displayed results do not automatically revise a saved print area. A worksheet-change macro may also miss changes caused only by formula recalculation, so that workflow needs a different trigger or a manual update.

Can I set a print area in Excel for the web?
Web printing options differ from desktop Excel, and VBA macros are not supported there. For a persistent print-area setup or macro automation, use desktop Excel and verify the result in its print preview.

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.