To set 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. Excel saves that range with the worksheet, so it remains the intended printout area when you preview or print the workbook.
What a print area does
A print area is a worksheet range that tells Excel which cells to include when printing that sheet. For example, if a worksheet contains a report in A1:F35 and working notes in H1:K80, you can set A1:F35 as the print area to keep those notes off the printed pages. The cells outside the area remain in the worksheet; setting a print area does not delete or hide them.
Print areas belong to individual worksheets, not to the entire workbook. You can give each sheet its own print area, or leave some sheets without one. If you print the whole workbook, Excel uses each worksheet’s print settings where they exist. The saved area is also different from a temporary selection made only for one print job.
Set a print area step by step
First select the range carefully. You can drag across cells, click the first cell and Shift-click the last, or enter a range in the Name Box to the left of the formula bar and press Enter. For a report with headings in row 1 and data through row 35, selecting A1:F35 includes both the headings and all six columns.
- Select the cells to include, such as A1:F35.
- Open the Page Layout tab on the ribbon.
- Choose Print Area in the Page Setup group.
- Choose Set Print Area.
- Check the result with File > Print or press Ctrl+P on Windows.
Excel marks the print area on the sheet, commonly with a border around its edges. The border is a guide, not a cell border that will appear on paper. If the preview includes too few cells or unwanted columns, return to the sheet and select the correct range before setting the area again.
Change, add, or clear an existing area
To replace an existing print area, select the new range and choose Page Layout > Print Area > Set Print Area. This resets the area to the selected cells. If you want to include another separate block while keeping the original block, select the additional cells and choose Page Layout > Print Area > Add Print Area. The new block becomes another print area on that worksheet.
To remove the saved setting, choose Page Layout > Print Area > Clear Print Area. Clearing it does not clear cell contents or formatting. Excel can then use its normal print range, which is generally based on the worksheet’s used cells and print settings. If you only want to print a different range once and do not want to alter the saved area, select the cells, open File > Print, and choose Print Selection in the print settings. The exact labels can vary slightly with the printer and Excel interface.
Print separated ranges and understand page output
You do not have to print one continuous rectangle. To select nonadjacent ranges on Windows, select the first range, then hold Ctrl while selecting each additional range. Use Page Layout > Print Area > Set Print Area after selecting them. Each separate area is treated as its own print area and is generally printed on a separate page or set of pages, rather than being pulled together as one continuous table.
For example, a summary in A1:D12 and a chart-support table in G1:J12 could be selected as separate blocks. Preview the result before printing: the blocks may occupy different pages, and the order can depend on the worksheet’s page order setting. If the blocks should appear together on one page, it is usually clearer to place them in one contiguous range or arrange the sheet layout accordingly, rather than expecting Excel to close the gap between them.
For a Mac, use the equivalent Command-click or drag selection for nonadjacent ranges where supported by the current Excel interface. Because selection behavior can depend on the way ranges are selected, inspect the print preview before relying on a multi-area printout.
Preview pages, margins, and scaling
A correct print area does not automatically guarantee a readable page. The selected cells might be wider than the paper, extend across several pages, or leave an awkward page break. Use File > Print to inspect the preview, or choose View > Page Break Preview to see how Excel divides the worksheet into pages. In Page Break Preview, you can inspect the page boundaries and adjust breaks when the layout needs it.
To make a wide report fit more neatly, check the orientation and scaling in Page Layout. Landscape orientation can suit a report with many columns. In the Scale to Fit controls, setting the width to one page and leaving the height automatic can keep the columns together while allowing rows to continue onto additional pages. Setting both width and height to one page can shrink a long report substantially, so it may make text difficult to read. Always judge scaling in the preview rather than assuming one-page output is automatically better.
Margins and paper size also affect the result. A range that fits on Letter paper with narrow margins might spill onto another page with different printer settings. If the preview looks unexpectedly small or has blank pages, check the selected print area, paper size, orientation, scaling, and page breaks in that order. A print area controls which cells are eligible to print; it does not decide how large the text appears or how the printer feeds paper.
Print area versus print titles and hidden cells
A common point of confusion is the difference between a print area and print titles. The print area defines which cells are included. Print titles repeat chosen rows or columns on each printed page, which helps readers identify column headings on a long report. To set repeating headings, use Page Layout > Print Titles and specify rows to repeat at the top or columns to repeat at the left in the Page Setup dialog. This setting complements a print area; it does not replace it.
Hidden rows and columns can also affect what appears in a printout. A range may include cells whose rows or columns are hidden, but hidden content is ordinarily not shown as visible printed data. If you need those values printed, unhide the relevant rows or columns and inspect the preview. Likewise, filtering a list changes which records are visible, but it is still worth checking the preview to confirm the intended records and headings are present.
Common problems and practical fixes
If Excel prints the whole sheet instead of the intended report, first confirm that the print area was set on the correct worksheet. Print areas are worksheet-specific, so setting one on a summary tab does not apply to the data tab. Next, check whether the print dialog is set to print the active sheet, the entire workbook, or a selection; those choices can lead to different output.
If new rows are missing, the saved area may simply stop at the old last row. A print area is a fixed range, so adding rows below it does not reliably expand the area just because the data is formatted as an Excel table. Extend or reset the print area after adding data. If a workbook is a recurring report, consider including a reasonable extra row range or updating the print area as part of the report-preparation routine.
If an unexpected blank page appears, look for a manual page break, a very wide or tall selected area, or scaling and paper-size settings that push part of the area onto another page. If unwanted notes print, reset the area to the report range or use Print Selection for a one-time job. Finally, save the workbook after changing its print settings if you want the setting to be available the next time the file is opened.
Excel on Mac and Excel for the web
In Excel for Microsoft 365 on Mac, the print-area commands are available from the Page Layout tab, with options to set or clear an area. The exact ribbon arrangement can differ from Windows. For printing, use File > Print or Command+P; the Windows shortcut is Ctrl+P. Review the Mac print preview because printer and page setup options may be presented differently.
Excel for the web does not provide the same full desktop workflow for saving and managing a worksheet print area through the Page Layout ribbon. Its print interface may let you print a selected range or worksheet, but that is not the same as setting a persistent print area in the workbook. If you need a saved print area that will be used consistently later, open the workbook in the desktop version of Excel, set the area there, and save the file.
Frequently Asked Questions
How do I set a print area in Excel?
Select the cells, then choose Page Layout > Print Area > Set Print Area. Use File > Print to confirm that the preview contains the intended range.
How do I remove a print area without deleting data?
Choose Page Layout > Print Area > Clear Print Area. This removes the print setting only; it does not delete, clear, or hide worksheet cells.
Can I set more than one print area on a worksheet?
Yes. Select an additional nonadjacent range and choose Page Layout > Print Area > Add Print Area. Preview the result because separate areas generally print as separate page sections.
Why is Excel not printing new rows I added?
The saved print area may not include the added rows. Select the expanded range and set the print area again, then check the preview. A table’s automatic growth does not necessarily extend a fixed print area.
Does a print area change what appears on the screen?
No. It controls the cells included in printing, not what is visible during normal worksheet editing. Cells outside the area remain available and can still be changed.
Can I print a range once without saving it as the print area?
Yes. Select the range, open File > Print, and choose Print Selection. This is useful for a one-off printout when you want to keep the worksheet’s saved print area unchanged.
Related
- Excel Autofill and Flash Fill: How Each Feature Works
- ArcGIS for Excel Heat Maps: Setup, Uses, and Limits
- Auto Flash Fill in Excel: How It Works and When to Use It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Clear Print Area: What Dotted Lines MeanTo clear a worksheet’s print area in Excel for Microsoft 365 on Windows, select the sheet and choose…
- How to Delete a Horizontal Page in WordTo delete a horizontal page in Word, remove the content on that page, then check its page and…
- How to Create a Calendar Template in Word That You Can ReuseTo create a reusable calendar template in Word, make a seven-column table for the days of the week,…
- Excel Dropdown List With Checkboxes: What WorksA standard Excel dropdown list cannot contain checkboxes: a Data Validation list lets you pick one item at…
- Flip the Order of Rows in Excel: Two Easy Methods That WorkTo flip rows in Excel while keeping each record together, add a helper column numbered from top to…
- Merge Cells in Excel When the Merge Option Is Greyed OutTo enable Merge & Center in Excel, select a normal, contiguous range of at least two cells, exit…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.