Print Area in Excel: Set, Change, and Fix It

A print area in Excel is a selected range of cells that Excel prints, leaving cells outside that range out of the printed output. In Microsoft Excel for Microsoft 365 on Windows, select the cells, then choose Page Layout > Print Area > Set Print Area; use the same menu to add to or clear the area later.

What a print area does

A worksheet can contain a large grid, but a useful printout often needs only a report, form, or summary within it. A print area tells Excel which part of a worksheet to include when printing. For example, if a budget occupies A1:F28 and notes or calculations continue in columns G through J, setting A1:F28 as the print area keeps those extra columns off the printout without deleting or hiding them.

The setting belongs to a particular worksheet, not the entire workbook. Each sheet can have its own print area, and a sheet can have more than one separate area. Print areas are saved with the workbook, so they generally remain in place when the file is saved and reopened. They affect printed pages and print previews, not the data shown in the worksheet itself.

A print area is not the same as selecting cells immediately before printing. A selection is a temporary choice for a print job; a defined print area is a persistent worksheet setting that controls what is included by default. That distinction matters when a workbook will be printed repeatedly or shared with someone else.

Set a print area in Excel for Windows

Use these steps in the desktop version of Excel for Microsoft 365 on Windows:

Open the worksheet and select the cells you want to print. Drag across the range, or select its first cell and Shift-click its last cell.
Choose Page Layout > Print Area > Set Print Area.
Open File > Print, or press Ctrl+P, and inspect the preview before printing.

The selected range becomes the worksheet’s print area. If the selection includes extra blank rows or columns, Excel can include them in the printed region, so check the selection carefully. You can also select a range by typing its address in the Name Box to the left of the formula bar, then apply the Print Area command.

On Excel for Mac, the equivalent command is on the Page Layout tab under Print Area; the ribbon layout can vary slightly by version. The print dialog shortcut is Command+P on Mac rather than Ctrl+P. Excel for the web has fewer page-layout controls than the desktop applications. If you need to create or manage a persistent print area and do not see the command in the web interface, open the workbook in desktop Excel.

Add ranges or change an existing print area

To include another section without replacing the current print area, select the additional cells and choose Page Layout > Print Area > Add to Print Area. For example, a worksheet might have a main table in A1:E20 and a small summary in G1:I6. Adding the second range can include both portions while leaving the intervening columns out.

Nonadjacent areas are useful when the information to print is separated on the sheet. On Windows, hold Ctrl while selecting additional ranges, then choose Set Print Area, or add a separate selection with Add to Print Area. On a Mac, use Command while selecting separate ranges. Excel treats separate print areas as distinct regions; they may print on separate pages rather than being joined into one continuous table. Check the preview to understand the resulting page arrangement.

If you want to replace the old area entirely, select the new range and choose Set Print Area. This resets the defined area to the new selection. To remove all defined print areas from the active sheet, choose Page Layout > Print Area > Clear Print Area. Clearing this setting does not erase cells, formulas, formatting, or page layout settings; it simply removes the range restriction.

Preview pages and control page layout

A correct print area does not guarantee a readable printout. The selected cells still have to fit the paper size, orientation, margins, and scaling. Use File > Print to review the preview, check the printer and paper settings, and look for clipped columns, unexpectedly small text, or extra pages. If only a portion of a table appears, first confirm that the print area includes all required columns and rows.

For a wide table, changing the orientation to landscape or choosing a larger paper size may preserve legibility. These options are available from the Page Layout tab and also appear in the print settings. The Scale to Fit controls on the Page Layout tab can constrain a sheet to a chosen number of pages wide or tall. In the print screen, Excel also offers scaling choices such as fitting the sheet on one page. Use these carefully: fitting a large report onto one page can shrink text until it is difficult to read.

Page breaks determine where Excel divides a print area across pages; they do not define which cells belong to the area. To inspect the breaks, choose View > Page Break Preview. You can adjust page breaks there, but the preview remains essential because the final arrangement also depends on paper size, margins, and scaling. A print area that spans multiple pages is not necessarily a problem if the breaks fall at sensible places.

Print area, print selection, and print titles

These three Excel features solve related but different printing problems:

Print area: Defines the worksheet cells included in printing by default. It is useful for a recurring report or a worksheet with calculations outside the intended output.
Print selection: Prints only cells selected for the current print operation. In File > Print, choose the option for printing the selection when available. This is handy for a one-time excerpt that should not become a lasting worksheet setting.
Print titles: Repeats specified rows or columns on each printed page. Set these through Page Layout > Print Titles. For example, repeating a table’s header row can make later pages understandable, but it does not expand or replace the print area.

A common misconception is that setting a print area automatically repeats the top row on every page. It does not. Define the print area to include the relevant table, then configure print titles separately if repeated headings are needed. Likewise, hiding columns is not a substitute for a print area: hiding changes what is visible in the worksheet, while a print area identifies the cells intended for the printed output.

Common print-area problems and fixes

Extra blank pages appear: Check whether the print area extends into empty rows or columns. Also inspect manual page breaks, scaling, and the preview. A stray formatted cell far from the main table can affect how much of a worksheet Excel considers in some print situations, so clear unnecessary formatting or reset the print area to the intended range.
The printout cuts off a column: Confirm that the column is inside the print area, then review orientation, margins, and scaling. A column outside the defined range will not appear just because it is visible next to the range on screen.
Excel prints an old range: The workbook may have a previously defined print area. Choose Clear Print Area, select the correct cells, and set it again. Then reopen File > Print to verify the new preview.
The print area looks right but text is tiny: Excel may be scaling the range to fit a page. Set the width or height to Automatic, use a more suitable orientation, or allow the content to span multiple pages instead of forcing everything onto one sheet.
Only one part of a separated layout prints as expected: Review how the selected areas are defined and inspect every preview page. Separate areas can be treated as separate print regions rather than one continuous block.

When troubleshooting a shared workbook, check the active worksheet. A print area set on one sheet does not automatically apply to other sheets, even if their layouts look similar. Also verify that the correct worksheet is selected in the print settings; printing an entire workbook is different from printing the active sheet.

Save, share, and maintain print settings

Because a print area is stored with its worksheet, save the workbook after setting or changing it. When sharing the file, include a brief note if recipients should print a particular sheet or use a special paper setup. They can inspect or change the print area in desktop Excel, and they can use File > Print to check the pages before sending them to a printer.

If a workbook is revised, revisit its print area. New rows added below a fixed range may be omitted, while deleted rows can leave an unnecessarily large area. For a regularly updated report, decide whether the print range should be expanded as the data grows. A fixed print area is predictable, but it does not necessarily adjust to new content automatically. Checking the range and preview after major edits prevents surprises.

Frequently Asked Questions

How do I see the print area in Excel?

Open File > Print to see the print preview. You can also choose View > Page Break Preview to inspect page boundaries. To see or edit the defined range itself, select the worksheet and use Page Layout > Print Area; the menu provides commands to set, add, or clear the area.

How do I remove a print area without deleting data?

Choose Page Layout > Print Area > Clear Print Area on the worksheet. This removes the print restriction but leaves the worksheet content and formatting intact.

Can I set more than one print area on a sheet?

Yes. Select additional nonadjacent cells and use Add to Print Area, or select multiple ranges before setting the area. Separate regions may print as separate areas, often on separate pages, so review the preview to confirm the layout.

Does a print area change what people see on the worksheet?

No. It affects the cells included in printed output, not what is displayed while working in the sheet. It also does not delete or hide cells outside the defined range.

Why is Excel not printing new rows I added?

The new rows may fall outside the existing fixed print area. Select the updated range and set the print area again, or add the new cells to the existing area. Check File > Print afterward to make sure the added rows appear on the intended pages.

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.