Excel Set Print Area: How to Print the Right Cells

To set a print area 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 that range rather than every cell on the worksheet.

What a print area does

A print area is a range of worksheet cells that Excel treats as the intended content for printing. It is useful when a worksheet contains supporting calculations, notes, or data tables that should stay in the workbook but should not appear on paper. For example, if a monthly report occupies A1:F32 and a calculation table sits in H1:K40, setting A1:F32 as the print area keeps the calculation table out of the report printout.

The setting affects printing, not the worksheet itself. It does not hide cells, delete data, or prevent someone from viewing or editing the rest of the sheet. Nor does it determine how the chosen cells fit on a page: page orientation, margins, scaling, and page breaks still affect the printed result.

Excel stores print-area settings with the worksheet in the workbook. Each worksheet can have its own print area, and a sheet without a defined print area generally prints its used content according to the print settings. A saved print area is therefore different from selecting cells temporarily for a one-time print job.

Set a print area step by step

Open the worksheet and select the cell range to include. Drag across the cells, or click the first cell and Shift-click the last cell.
Open the Page Layout tab on the ribbon.
Choose Print Area in the Page Setup group, then select Set Print Area.
Check the result with File > Print or in Print Preview before sending it to a printer.

For a precise range, you can use the Name Box to the left of the formula bar: type a reference such as A1:F32, press Enter, and then use the same Page Layout command. The range reference is only an example; replace it with the cells your report uses. If the selected cells contain blank rows or columns, those blanks may still take up space in the printed range.

On Excel for Mac, the equivalent command is available from Page Layout > Print Area > Set Print Area. The ribbon layout can look a little different by version, but the command name is the same. Excel for the web does not provide the desktop command for defining a saved print area; open the workbook in the desktop app to set or change one.

Change or clear a saved print area

To replace the current print area, select the new range and choose Page Layout > Print Area > Set Print Area again. Excel makes the newly selected range the print area for that sheet. This is often the simplest fix after adding rows to a report or reorganizing a table.

To remove the saved restriction, choose Page Layout > Print Area > Clear Print Area. Excel then returns to printing the worksheet’s content according to the other print settings. Clearing the print area does not clear cell contents or formatting.

If you are unsure whether a print area exists, select the worksheet and inspect the Print Area menu. You can also open Print Preview: a defined range may be apparent from the pages shown, though page setup can make the preview span more than one page. Clear and reset the area if the preview contains unexpected cells.

Use more than one range

Sometimes a report has separate blocks that should print while the cells between them should not. Select the first range, then hold Ctrl on Windows while selecting additional non-adjacent ranges. On a Mac, use Command while selecting additional ranges. Choose Page Layout > Print Area > Set Print Area after the ranges are selected.

Excel treats separated print areas as distinct areas; they may print on separate pages rather than being assembled as one continuous table. That can be handy for two independent forms, but it may produce a page for each block and leave awkward whitespace. Check Print Preview, and consider copying the blocks onto a print-specific sheet if the desired result is a single, carefully arranged page.

To add a range to an existing print area instead of replacing it, select the extra cells and choose Page Layout > Print Area > Add to Print Area. Use this when a report grows and its current area should be retained. If the added cells are adjacent to the existing area, review the preview anyway: the combined rectangular space may include intervening cells.

Check page breaks and fit the range to paper

A print area decides which cells are eligible to print; it does not guarantee that they fit on one page. A range that is wide or long can span several pages. To inspect the layout, open View > Page Break Preview. The page boundaries show where Excel will divide the content. Return to View > Normal when you are finished adjusting the layout.

For a wide table, try landscape orientation and suitable margins before reducing the scale. Use Page Layout > Orientation > Landscape to rotate the page, and review Page Layout > Margins for the available margin presets. A smaller scale can squeeze columns onto a page, but making everything fit on one page may render text too small to read.

Excel’s scaling controls are in the Page Layout tab’s Scale to Fit group. For example, setting Width to 1 page while leaving Height set to Automatic can fit a broad table across one page while allowing it to continue down additional pages. Conversely, fitting both width and height to 1 page forces the entire print area onto a single page, which is not always practical for a long report. Check the preview at the actual paper size before printing.

Repeat headings on every printed page

A multi-page print area can be hard to read if its column headings appear only on the first page. Print titles solve a different problem from print areas: they repeat specified rows or columns on each printed page, while the print area sets which cells are included. To repeat a heading row in Excel for Windows, go to Page Layout > Print Titles. In the Page Setup dialog, use the Rows to repeat at top box to specify the row or rows, then confirm with OK.

For instance, if row 1 contains the table headings, specify $1:$1 as the row to repeat. This does not expand the print area or make other rows repeat. The print titles command is not available in the same way in Excel for the web, so use the desktop app to configure it. Repeat headings are particularly valuable for long lists that span several pages vertically.

Common problems and practical fixes

Extra cells appear: The range may have been selected too broadly, or an old print area may still include cells you no longer want. Set the intended range again, then inspect Print Preview.
Part of the table is missing: Reset the print area to include the omitted rows or columns. Also check whether the sheet has multiple print areas that were created unintentionally.
The result is too small: Avoid forcing both width and height to one page for a large table. Fit only the width, use landscape orientation, or allow more pages.
A blank page prints: Look for stray content, formatting, or a separate print area beyond the main report, and review page breaks. Clearing the print area and setting it again to the actual report range can help isolate the cause.
The printout differs from the screen: A worksheet view is not a reliable preview of paper layout. Check paper size, orientation, margins, scaling, and page breaks in File > Print.

One common misconception is that setting a print area hides everything outside it. It does not: the other cells remain visible in Normal view and remain part of the worksheet. If you need to exclude sensitive information from a file, a print area is not a security control; remove or protect the data appropriately rather than relying on print settings.

Print a selection once instead

If you only need a one-time printout of a few cells, you may not need to save a print area. Select the cells, open File > Print, and choose Print Selection from the Settings options. This prints the selected range for that job without changing the worksheet’s saved print-area setting. The exact options shown depend on the current selection and workbook.

Use a saved print area for a recurring report that should print the same region whenever someone prints that sheet. Use Print Selection for an occasional extract or quick handout. If the sheet already has a print area, preview the chosen output carefully so you can confirm whether the setting or the temporary selection is governing the job.

Save, share, and print from different versions

Save the workbook after changing its print area if you want the setting to travel with the file. When sharing the workbook, remember that a recipient can change the print area and other page setup options. Printer drivers, paper sizes, and installed fonts can also affect pagination, so a layout that looks right on one computer may need a quick preview on another.

In Excel for the web, open a workbook in the desktop version when you need to create or edit its saved print area. Web printing options and interface details can differ, so a practical workflow is to set up the print layout in desktop Excel and then use the browser’s available print flow only after checking the result. In Windows desktop Excel, Ctrl+P opens the print screen; on Mac, use Command+P. These shortcuts open print options, but they do not set a print area.

Frequently Asked Questions

How do I set a print area in Excel?
Select the cells, then choose Page Layout > Print Area > Set Print Area. Check File > Print to verify which pages Excel will produce.

How do I remove a print area in Excel?
Choose Page Layout > Print Area > Clear Print Area. This removes the saved print restriction without deleting worksheet data.

Can I set multiple print areas in one worksheet?
Yes. Select non-adjacent ranges using Ctrl on Windows or Command on Mac, then set the print area, or use Add to Print Area to extend an existing one. Preview the result because separate areas can print as separate blocks or pages.

How do I make an Excel print area fit on one page?
In Page Layout, use the Scale to Fit controls to set both width and height to 1 page. For a long table, fitting only the width is often more readable because the rows can continue onto additional pages.

Can I set a print area in Excel for the web?
The desktop command for defining a saved print area is not available in Excel for the web. Open the file in Excel for Microsoft 365 on Windows or Excel for Mac to set or change the print area.

Does a print area hide cells outside the range?
No. It controls what is included when printing that worksheet; it does not hide, delete, or protect the remaining cells.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.