Spreadsheet Print Area: Set, Preview, and Fix Printing

A spreadsheet print area is the range of cells Excel is instructed to print; set it by selecting the cells, then choosing Page Layout > Print Area > Set Print Area in Excel for Microsoft 365 on Windows. It helps keep a printout focused on the useful part of a worksheet instead of including empty columns, notes, or unrelated tables.

What a print area does

A print area defines which worksheet cells are included when you print that sheet. For example, if a worksheet contains a monthly sales table in A1:F35, a chart in H2:N18, and scratch calculations farther down, setting A1:F35 as the print area tells Excel to print the table rather than the whole worksheet’s used range. The setting belongs to the worksheet, so another sheet in the same workbook can have its own print area.

It is a print instruction, not a way to hide or delete data. Cells outside the area remain visible and editable on screen, and formulas that refer to them continue to work. The area is stored with the workbook, so it normally remains in place when the workbook is saved and reopened. Someone opening the file may still choose different print settings or print a selection instead.

A print area also does not guarantee that the selected cells will fit on one sheet of paper. It controls what is included; paper size, orientation, margins, scaling, and page breaks determine how that content is laid out. Those settings need to be checked separately.

Set a print area in Excel

On Windows, use this sequence in Excel for Microsoft 365:

Select the cell range to print, such as A1:F35. Drag across the cells, or click the first cell, hold Shift, and click the last cell.
Open the Page Layout tab.
Choose Print Area in the Page Setup group, then select Set Print Area.
Open File > Print to inspect the preview before sending the job to a printer or saving it as a PDF.

Excel marks the selected cells as the print area. If the range is too wide or long for one page, the preview may show multiple pages. That is expected: setting the area limits the content but does not automatically compress it to one page.

In Excel for Mac, select the cells and use Page Layout > Print Area > Set Print Area when those controls are shown on the ribbon. Ribbon layout can vary with window size and version, so expand the ribbon if the group is hidden. Printing is available from File > Print; Command+P is the Mac shortcut, compared with Ctrl+P on Windows.

Change, add, or clear the range

To replace an existing print area, select a new range and choose Page Layout > Print Area > Set Print Area. The new selection becomes the area for that worksheet. To remove the restriction and let Excel print the sheet’s content according to the other print settings, choose Page Layout > Print Area > Clear Print Area. Clear Print Area applies to the active sheet, so check which worksheet is selected first.

You can include separate, non-adjacent blocks. Select the first range, then hold Ctrl on Windows while selecting additional ranges; on Mac, use Command while selecting the extra ranges. Choose Page Layout > Print Area > Add to Print Area to append the selection to an existing area. Excel treats separate blocks as separate print areas and prints them on separate pages. This can be useful for two small tables that should not include the blank columns between them, but it may produce a less convenient page order than arranging the tables together in one continuous range.

If an area was set accidentally, clearing it is often simpler than trying to adjust it cell by cell. Then select the intended rectangle and set it again. Remember that clearing a print area does not clear manual page breaks or reset margins and scaling; those are separate page-layout settings.

Preview pages and adjust layout

Use File > Print to see how the current worksheet will be divided into pages. The preview helps reveal clipped columns, unexpected blank pages, text that is too small, and tables that break in awkward places. To return to the sheet, use the back arrow or press Esc. You can also open View > Page Break Preview to see page boundaries on the worksheet and adjust where pages divide.

For a table with several columns, try landscape orientation before shrinking the whole page. On the Page Layout tab, use Orientation > Landscape. Check paper size with Page Layout > Size and margins with Page Layout > Margins. These settings can make a wide report easier to read without forcing every column into a narrow portrait page.

If the content should fit on one page, use the scaling controls carefully. In File > Print, open the No Scaling menu and choose Fit All Columns on One Page to keep columns together while allowing rows to continue onto additional pages. Fit Sheet on One Page compresses both width and height, which can make a large worksheet’s text unreadably small. On the Page Layout tab, the Scale to Fit controls also let you set a page width or height. Preview the result and choose legibility over forcing a large report onto a single sheet.

Print area versus other printing controls

Several Excel features sound similar but solve different problems:

Print area: selects which worksheet cells are eligible to print.
Print Selection: prints the cells selected for that print job, rather than relying on the usual active-sheet output. In File > Print, choose Print Selection in the settings when that option is appropriate.
Page breaks: determine where included content is divided between pages. Use Page Layout > Breaks to insert or remove breaks; Reset All Page Breaks removes manual breaks on the active sheet.
Print titles: repeat chosen rows or columns on each printed page. Use Page Layout > Print Titles to specify, for example, a heading row to repeat at the top.

For a long table, a useful combination is a print area covering all of the data, a repeated header row, and page breaks that avoid splitting key sections. Repeating a header does not expand or restrict the print area; it changes what appears at the top of each page.

Common print-area problems

The printout includes too much. Check that the correct sheet is active and that its print area is set as intended. Open File > Print and confirm the settings are not set to Print Entire Workbook or Print Selection unexpectedly. If the sheet has no print area, Excel may include other populated or formatted cells in its output.

Some columns or rows are missing. The selected print area may exclude them, or a scaling and page-break choice may make the page division hard to notice. Recheck the range and preview every page. If columns spill to an extra page, landscape orientation or Fit All Columns on One Page may help.

A blank page appears. Look for an oversized print area, a manual page break, or content extending into another page. Page Break Preview can show the boundaries. Remove an unwanted manual break with Page Layout > Breaks, or use Reset All Page Breaks if you want to discard all manual breaks on that sheet. Resetting breaks does not clear the print area.

The text is tiny. Excel may be scaling a large range to fit a single page. Change the scaling option, allow more pages, or print only the relevant columns. A report spread across two readable pages is usually more useful than a complete but illegible page.

The printout differs from the preview. Check the chosen printer, paper size, orientation, and margins. A printer can have different printable margins or available paper sizes from the settings used when the workbook was laid out. Preview again after changing the destination or page setup.

Practical example: a monthly report

Suppose a worksheet has a report in A1:G42, a small explanatory note in I2:J6, and calculations in A50:D70. If the printed report should contain only the table, select A1:G42 and set that as the print area. In the preview, choose landscape if the seven columns feel cramped. If the table spans several pages vertically, use Page Layout > Print Titles to repeat the row containing its column labels.

If the note must also be printed, either place it within the report’s continuous range or add it as a separate print area. The separate-area approach may put the note on its own page, so including it in a compact, continuous layout is often more predictable. The calculations remain in the worksheet but are not included unless the print area is expanded or the print settings are changed.

Frequently Asked Questions

Is a print area the same as hiding rows or columns?
No. Hiding rows or columns changes what is displayed and can affect other work on the sheet. A print area only limits the cells included in normal worksheet printing; cells outside it remain available.

How do I remove a print area in Excel?
Activate the worksheet, then choose Page Layout > Print Area > Clear Print Area. This removes that sheet’s print-area restriction, but it does not reset scaling, margins, or page breaks.

Can I print two separate ranges on one page?
You can add non-adjacent ranges to a print area, but Excel treats them as separate print areas and prints them on separate pages. To place content together on one page, arrange it in a continuous range or copy it to a print-ready sheet.

Does setting a print area make the rest of the spreadsheet disappear?
No. It affects printing only. It does not delete, hide, or protect cells outside the area, and it does not change formulas or worksheet data.

Why does Excel print blank pages even with a print area?
Check the area’s size, manual page breaks, and content that crosses a page boundary. Page Break Preview can help identify the cause. Also confirm the print settings and paper size in File > Print, since these can affect pagination.

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

More in Errors & fixes

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

Spotted an error in this guide? Let us know.