How to Change the Print Area in Excel (And Why It Matters)

Printing from Excel can feel unpredictable. You hit Print, and suddenly a sprawling spreadsheet spills across a dozen pages — or worse, critical columns get cut off entirely. The solution usually comes down to one underused feature: the print area.

Understanding how to set, change, and clear print areas puts you back in control of what actually comes out of the printer.

What Is a Print Area in Excel?

A print area is a defined range of cells that Excel will print — and only that range. When no print area is set, Excel defaults to printing all cells that contain data, which often includes formatting, headers, or helper columns you never intended to share.

Setting a print area tells Excel: start here, stop there. It becomes a persistent setting saved with the workbook, meaning it stays in place every time you or someone else opens the file and prints.

Print areas are especially useful for:

• Dashboards where only a summary section should be printed
• Templates with input areas alongside formula columns that shouldn't be visible
• Reports pulled from larger data tables where only a subset is relevant

How to Set a Print Area in Excel

Method 1: Using the Page Layout Ribbon

1. Select the cell range you want to print — click and drag across the cells, or hold Shift and use the arrow keys.
2. Go to the Page Layout tab in the ribbon.
3. Click Print Area in the Page Setup group.
4. Select Set Print Area.

A dashed border will appear around your selected range, confirming it's been set. Excel will now print only those cells.

Method 2: Through the Page Setup Dialog

1. Go to Page Layout → Page Setup (click the small arrow in the bottom-right corner of the Page Setup group).
2. Click the Sheet tab.
3. In the Print area field, type the cell range manually (e.g., A1:F30) or click the range selector icon to highlight it on the sheet.
4. Click OK.

This method is particularly useful when you already know the exact range or want to review other print settings — scaling, gridlines, row/column headers — at the same time.

Method 3: Define It in Name Manager

Power users sometimes define print areas via Formulas → Name Manager, editing the named range called Print_Area. This approach works well when building dynamic workbooks or templates programmatically, but it's not necessary for most users.

How to Change or Update an Existing Print Area 🖨️

If a print area is already set and you need to adjust it:

To replace it entirely:

• Select your new desired range.
• Go to Page Layout → Print Area → Set Print Area.
• The old print area is overwritten.

To expand it without replacing:

• Select the additional cells you want to include.
• Go to Page Layout → Print Area → Add to Print Area.

Note: Excel may split non-adjacent added ranges into separate print areas, which can result in them printing on separate pages. Adjacent ranges merge cleanly into one.

To clear it:

• Go to Page Layout → Print Area → Clear Print Area.
• Excel returns to its default behavior and will print all data-containing cells.

How Print Areas Interact With Page Breaks

Setting a print area and managing page breaks are related but separate controls. Even within a defined print area, Excel automatically inserts page breaks based on:

• Paper size and orientation (Portrait vs. Landscape)
• Scaling settings
• Row heights and column widths

You can view and adjust these in View → Page Break Preview. Dashed lines are automatic breaks; solid blue lines are manual ones you've set. Dragging these lines lets you control exactly where each printed page begins and ends — independently of the print area boundaries.

Working With Multiple Sheets and Print Areas

Each worksheet in a workbook has its own independent print area. If you're printing an entire workbook, Excel applies each sheet's print area setting separately.

If you need consistent print areas across multiple sheets — for example, in a quarterly report workbook — you'll need to set them on each sheet individually, or use a macro to apply them uniformly.

Variables That Affect Your Results 📋

Changing the print area is straightforward, but how the output looks depends on factors beyond just the range:

• Excel version: The ribbon layout is consistent across Excel 2016, 2019, 2021, and Microsoft 365, but older versions (2010 and earlier) may have slight differences in menu placement.
• Operating system: Excel for Mac places some options differently than the Windows version — Page Setup is accessed through the File menu on Mac rather than the Page Layout ribbon dialog.
• Shared workbooks: If a file is shared or protected, print area settings may be locked or may not save depending on permission levels.
• Dynamic data: If your data range changes frequently (new rows added weekly, for instance), a static print area will either miss new data or include empty rows. Named ranges with dynamic formulas can help, but they add complexity.
• Printer drivers: Scaling and margin rendering can vary slightly between printer models, which affects how tightly your defined print area fits on a page even when the range itself is correct.

When the Print Area Doesn't Behave as Expected

A few common situations catch people off guard:

The print area reverts or doesn't save — This usually happens with file formats. Print area settings are saved in .xlsx and .xlsm files but may not persist correctly in .csv or older .xls formats.

Extra blank pages appear — Often caused by a stray cell with formatting (but no visible content) sitting outside the intended range. Use Ctrl+End to find the last cell Excel recognizes as containing data.

The wrong range prints after sharing the file — Whoever last saved the file controls the saved print area. Teams using shared files should establish a standard or protect the sheet's print settings.

How much any of these variables affects your specific situation depends on your workflow, the version of Excel you're running, and how your spreadsheets are structured — which is something only your own setup can reveal.