Microsoft Excel Print Area: Set, Change, and Clear

In Microsoft 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 as the worksheet’s print area, so printing the sheet includes the chosen cells rather than automatically printing every part of the sheet that contains content.

What an Excel print area does

A print area is a saved instruction that limits which cells from a worksheet are included when you print. It is useful when a worksheet contains supporting calculations, notes, lookup tables, or several reports but only one section belongs on paper. For example, if a sales worksheet has a customer-facing summary in A1:F25 and detailed calculations in H1:N80, setting A1:F25 as the print area keeps the calculations out of the printed report.

The print area affects printing and print preview, not what appears on the screen. It does not delete, hide, or protect cells outside the area, and it does not change the workbook’s data. You can still select and edit the rest of the worksheet normally. The setting is saved with the workbook and applies to an individual worksheet, rather than acting as one universal print range for every sheet.

Set a print area step by step

To create a print area in Excel for Microsoft 365 on Windows:

Select the cells you want on the printed page. Drag across a range, or select a cell and use Shift-click or the arrow keys with Shift to extend the selection.
Open the Page Layout tab on the ribbon.
Select Print Area, then select Set Print Area.
Choose File > Print, or press Ctrl+P, to inspect the result before sending it to a printer.

Excel outlines the saved range when the worksheet is active. The outline is a visual guide; it does not print as a border. If you select the wrong cells, you can set a different area or clear the existing one and start again. The Windows ribbon path is also available in current desktop Excel for Mac, though ribbon layout can vary with the window size and version. On Mac, use Command+P to open the print screen.

In Excel for the web, printing a worksheet is available, but the desktop app is needed to set or edit a worksheet’s print area. If you need a saved, reusable print range, open the workbook in the desktop version of Excel, set it there, and save the workbook.

Include more than one range

A print area can contain separate, nonadjacent ranges. This can help when a report has two small tables that should print but the cells between them should not. Select the first range, then hold Ctrl while selecting additional ranges. With the ranges selected, choose Page Layout > Print Area > Set Print Area. To add another selection to an existing print area instead, select the new cells and choose Page Layout > Print Area > Add to Print Area.

Separate areas do not become one continuous block with the empty space removed. Excel treats nonadjacent areas as separate print areas, and they can print on separate pages. Check the preview carefully: a layout that looks compact on screen may use more paper than expected, and each area may have its own page layout. If the ranges belong together as one report, it may be simpler to include the cells between them and format or hide irrelevant rows and columns.

Preview and adjust the printed pages

Print preview is the quickest way to see what the print area will actually produce. Choose File > Print or press Ctrl+P on Windows. Look at every page in the preview, not only the first one. Confirm that the intended content appears, that labels are readable, and that no important columns or totals have fallen onto an extra page. Use the page navigation controls in the print screen if the report spans several pages.

If the content is cut off or split awkwardly, return to the worksheet and inspect the print area outline and page breaks. The Page Layout tab includes Page Setup options for paper size, orientation, margins, and scaling. Landscape orientation can suit a wide table, while portrait may work better for a narrow report. A manual page break can control where content moves to another page; view page breaks through View > Page Break Preview, then adjust breaks if needed.

Remember that print preview reflects more than the selected range. Printer settings, paper size, margins, scaling, and page breaks all affect the final pages. If the preview changes after choosing another printer or paper size, revisit the layout rather than assuming the saved print area has changed.

Fit a print area without making it unreadable

For a wide or long range, use the Scale to Fit controls on Page Layout or open the Page Setup dialog for more print settings. Setting Width to 1 page can keep all columns together while allowing rows to continue onto additional pages. Setting Height to 1 page attempts to fit all rows on one page. Setting both Width and Height to 1 page forces the entire area onto a single sheet of paper.

That last option can shrink a large table until its text is difficult to read. Use it only when the range is small enough to remain legible. For a large report, fitting the width to one page while letting the height span multiple pages is often more practical. You can also reduce margins, change orientation, or adjust column widths before resorting to heavy scaling. Always check the preview at a realistic paper size; a page that technically fits may still be unusable in print.

Change or clear an existing print area

To replace the current range, select the new cells and choose Page Layout > Print Area > Set Print Area. This sets the selected range as the print area for that worksheet. To remove the saved restriction, choose Page Layout > Print Area > Clear Print Area. With no print area saved, Excel generally prints the worksheet’s used content, subject to print settings and page layout.

Clearing a print area does not clear the worksheet, remove formatting, or reset all page setup options. If the output still looks unusual afterward, check for hidden rows or columns, filters, manual page breaks, scaling, or a different print selection. Print areas are stored separately for worksheets, so clearing the area on one sheet does not automatically remove areas on other sheets.

Common print-area problems

Extra blank pages: The print area may extend farther than the visible report, or formatting and stray content may make Excel treat distant cells as part of the used sheet. Check the print area outline, clear or reset the area, and inspect the preview page by page.
Missing rows or columns: Rows or columns hidden in the worksheet do not appear in the printed output. A filter can also hide records. Unhide the needed cells or change the filter before printing.
Content appears too small: A one-page width-and-height fit may be shrinking a large range. Let the sheet span multiple pages in height or adjust orientation and margins.
The wrong range prints: Verify which worksheet is active and whether a print area is already saved. If you want only a temporary selection, use the Print Selection option in the print settings rather than changing the saved area.
The printout differs between computers: Printer drivers, paper sizes, and default margins can affect pagination. Check the destination printer and paper settings in File > Print before relying on page breaks.

Print area versus printing a selection

A saved print area and Print Selection solve related but different problems. A print area is a worksheet setting that remains in the workbook and can be reused later. Print Selection is useful when you want to print a range once without changing the sheet’s saved print setup. Select the cells, open File > Print, and choose Print Selection from the print settings. Check the preview before printing to confirm that Excel is using the selection you intended.

Use a saved print area for recurring reports, such as a monthly summary that is printed from the same worksheet. Use Print Selection for a one-off extract or a quick copy of a few cells. Neither option changes the underlying data. If other people use the workbook, a saved print area can make routine printing more predictable, but it is still worth checking the preview after the data or layout changes.

How Excel stores print areas

Excel stores a worksheet’s print area as a workbook-defined name, commonly shown as Print_Area, with a scope tied to that sheet. You can inspect defined names through Formulas > Name Manager. This explains why a print area can persist after saving and reopening a workbook, and why each worksheet can have its own range. Most users do not need to edit the name directly; using the Print Area menu is less error-prone because Excel updates the saved range for you.

If you copy a worksheet or move a workbook between desktop Excel and other spreadsheet programs, check its print setup afterward. Compatibility and page layout can vary, and the visible cells alone do not tell you whether a print area is saved. A preview is the reliable check for the copy of the workbook you intend to print.

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 the result in preview.

How do I remove a print area in Excel?
On the worksheet with the saved area, choose Page Layout > Print Area > Clear Print Area. Repeat on other sheets if they have their own print areas.

Can I print two separate ranges on one worksheet?
Yes. Select the ranges together and set them as the print area, or use Add to Print Area for an additional range. Separate areas may print on separate pages, so check the preview.

Why is Excel printing blank pages?
The print area may include empty cells, or the worksheet may have distant formatted content, hidden page breaks, or scaling settings that create extra pages. Inspect the print area and preview, and check paper size and page breaks.

Can I set a print area in Excel for the web?
Excel for the web can print, but setting or editing a saved print area requires desktop Excel. Open the workbook in the desktop app, set the area on the Page Layout tab, and save it.

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.