Set Print Area in Excel: Steps, Pages, and Fixes

In Excel for Microsoft 365 on Windows, select the cells you want to print, then choose Page Layout > Print Area > Set Print Area. Check the result with File > Print; Excel will print the defined range instead of the whole worksheet.

What a print area does

A print area is a range of cells that Excel treats as the printable part of a worksheet. It is useful when a sheet contains working notes, calculations, reference lists, or other material that should stay on screen but should not appear on paper. You can define a print area on each worksheet independently, so setting one on a summary tab does not set it on every tab in the workbook.

The setting is saved with the workbook. That means someone opening the saved file can see the same print area, although their printer, paper size, and page settings can affect how the range is laid out. A print area does not delete, hide, or protect cells outside it; it only controls what Excel includes when printing that sheet.

Set a print area step by step

Open the worksheet you want to print. If you need only part of the sheet, identify the first and last cells of that block.
Select the range by dragging across the cells, or click the first cell, hold Shift, and click the last cell. For example, select A1:F28 to print a six-column report with 28 rows.
On the ribbon, choose Page Layout > Print Area > Set Print Area.
Choose File > Print to inspect the preview. Confirm that the expected cells appear and that no important columns or rows are cut off.

After defining the area, you can continue editing cells inside or outside it. If you later add a new report row below the selected range, Excel does not necessarily include that new row automatically. Review the print preview after structural changes, and update the area if the report has grown.

Change or clear an existing print area

To replace the current area, select the new range and use Page Layout > Print Area > Set Print Area again. Excel uses the new selection as the print area for that worksheet. If the goal is to expand a single rectangular block, selecting the full desired range again is usually the clearest approach.

To remove the restriction and return to printing the worksheet’s used content, choose Page Layout > Print Area > Clear Print Area. Clearing the area does not erase cells or formatting. It only removes the print-area definition. If you are unsure whether a print area is already set, open the Print Area menu or check the preview: a preview showing only an unexpected portion of the worksheet is a common clue.

Print separate ranges from one worksheet

You can define more than one separate block as a print area. Select the first range, then hold Ctrl while selecting each additional range, and choose Page Layout > Print Area > Set Print Area. Each selected block is a separate print area; Excel generally prints the separate areas on different pages rather than arranging them together as one continuous table. This works for, for example, two small summary tables that sit far apart on a sheet.

On a Mac, use Command while selecting nonadjacent ranges instead of Ctrl. If the ranges need to appear together on one page, consider copying them to a clean report sheet and arranging them there. That gives you more predictable control over spacing and page layout than relying on separate areas.

Check page layout before printing

A correct print area can still produce an awkward printout if its dimensions do not suit the paper. Use File > Print to inspect the page preview, including the number of pages and whether the last column or row spills onto another page. The preview is more reliable than judging the worksheet from its on-screen zoom, because screen zoom does not set print size.

For a wide table, try Page Layout > Orientation > Landscape. To use a different sheet of paper, select Page Layout > Size and choose a supported size. Margins are controlled through Page Layout > Margins. Available paper sizes and printer options depend on the selected printer and its driver.

If the report should fit across one page, use the Scale to Fit controls on the Page Layout tab and set Width to 1 page. Leaving Height as Automatic can keep a long report readable across several pages vertically. Setting both width and height to one page may shrink a large worksheet so much that its text is difficult to read. Always judge the result in Print Preview, not just by the fact that it fits.

Print headings and manage page breaks

A print area decides which cells are included, but it does not automatically repeat a table’s column headings on every page. For a long report, use Page Layout > Print Titles. In the Page Setup dialog, set the row or rows to repeat at the top, such as $1:$1 for row 1. This makes later pages easier to interpret when the printout spans multiple pages.

Page breaks determine where included content is divided between pages. To inspect or adjust them, choose View > Page Break Preview. Drag a page-break line to change the split, or return to View > Normal when finished. A page break does not add cells to the print area: it only changes how the selected content is divided. This distinction matters when a column is missing altogether versus when it appears on an unexpected page.

Print a selection without saving a print area

A permanent print area is not always necessary. If you only need a one-time printout, select the cells, choose File > Print, and change the print setting from the default option to Print Selection. This prints the current selection without changing the worksheet’s saved print-area setting. It is useful when a colleague needs the full report later but you only need a small excerpt now.

Use a saved print area when the same defined portion should be printed repeatedly or shared as the workbook’s intended report. Use Print Selection when the choice is temporary. In either case, review the preview: selection, print area, page orientation, and scaling each affect the output in different ways.

Common problems and practical fixes

Only part of the intended table prints: The saved print area may be too small. Select the complete range and set it again, then inspect the preview.
Old cells keep appearing: Clear the print area and define it again. Also check whether separate ranges were included unintentionally.
The printout is tiny: Check whether both width and height are set to fit one page. Allow more pages, switch to landscape, or adjust margins rather than shrinking every row and column.
A new row is missing: The print area may not include cells added after it was set. Expand or reset the area to cover the updated report.
The paper output differs from the preview: Check the selected printer, paper size, and printer properties. A printer’s supported paper sizes or printable margins can differ from another device’s.

In Excel for the web, printing and page-layout controls are more limited than in the Windows desktop app, and the full desktop Print Area workflow may not be available. If you need to create or carefully manage a saved print area, open the workbook in Excel for Microsoft 365 on Windows or Excel for Mac. The Mac ribbon has similar Page Layout commands; use Command+P rather than Ctrl+P to open printing on Mac. On Windows, Ctrl+P opens the Print screen.

Frequently Asked Questions

How do I set a print area in Excel?
Select the cells, then choose Page Layout > Print Area > Set Print Area. Open File > Print to confirm the output.

How do I remove a print area in Excel?
Choose Page Layout > Print Area > Clear Print Area. The cells remain unchanged; Excel simply stops restricting printing to that defined range.

Can I set multiple print areas on one sheet?
Yes. Select the first range and then Ctrl-select additional ranges on Windows, or Command-select them on Mac, before setting the print area. Separate areas generally print on separate pages.

Why is Excel printing blank pages?
Check for an oversized print area, stray formatting far below or beside the report, and page breaks that create extra pages. Clear and reset the print area if needed, then check Print Preview before printing.

Does a print area change what other people see in the worksheet?
No. It does not hide or remove cells from the sheet. It affects the worksheet’s print output, while the full grid remains available when someone views or edits the workbook.

How do I fit an Excel printout onto one page?
In the Page Layout tab’s Scale to Fit controls, set Width and Height to 1 page. For long reports, fitting only the width and allowing multiple pages in height is often easier to read.

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.