Add a Print Area in Excel: Setup, Options, and Fixes

How-to basics · Updated November 18, 2026

To add a print area in 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 with the worksheet, so it remains the print area when you save and reopen the workbook.

A print area is useful when a worksheet contains notes, calculations, or other material that should stay on screen but not appear on paper or in a PDF. You can replace the area, add another range, or clear it whenever the report changes.

What a print area does

A print area tells Excel which cells on a particular worksheet to include when printing. It does not delete, hide, or protect cells outside the selected range; those cells remain available for editing and viewing. Think of it as a saved print boundary rather than a change to the worksheet itself.

For example, a sales sheet might use columns A through F for a monthly report, while columns G through J contain working notes and checks. Setting A1:F32 as the print area keeps the report focused without requiring you to move or remove the extra columns. Excel then paginates that range according to the worksheet’s paper size, margins, orientation, scaling, and page breaks.

Print areas are set separately for each worksheet. Setting one on a Summary sheet does not automatically set one on a Detail sheet. The saved area is also different from the cells you select temporarily: a temporary selection does not become a persistent print area unless you choose the Set Print Area command.

How to set a print area

Use the ribbon in desktop Excel for Windows. First select the exact range, including any heading rows or columns that should appear on the printed page. Then set it as the print area:

  1. Open the worksheet you want to print.
  2. Select the cells to include. You can drag across the range, or click the Name Box to the left of the formula bar, type a reference such as A1:F32, and press Enter.
  3. Choose Page Layout > Print Area > Set Print Area.
  4. Open File > Print to inspect the preview before printing or saving as a PDF.

In this example, selecting A1:F32 includes the top-left cell A1 through F32, inclusive. If the selection misses a title, a totals row, or the final column, return to the worksheet and set the range again. The preview is a quick way to catch those omissions.

On Excel for Mac, select the range and use Page Layout > Print Area > Set Print Area as well; the ribbon layout can differ slightly by window size and Excel release. To inspect printing options on Mac, use File > Print. Excel for the web has more limited page setup controls: for full print-area management, open the workbook in the desktop app.

Add a range to an existing print area

Choosing Set Print Area again replaces the current print area with the newly selected cells. To keep the original area and include an additional selection, choose Page Layout > Print Area > Add to Print Area instead. This distinction matters when a worksheet has separate report blocks that should both print.

For instance, suppose A1:D18 contains a summary and A24:D35 contains a small detail table. Set the first block as the print area. Select the second block and choose Add to Print Area. Excel retains both selections. Disconnected print areas are treated as separate print regions and may print on separate pages, so inspect the preview to see how they paginate. They will not necessarily sit beside each other as they do on the worksheet.

If you want a single continuous table, it is often better to set one rectangular range that includes the cells between the sections. That may also include blank rows, but it avoids managing disconnected regions and can make the printed layout more predictable. If you add the wrong selection, the simplest correction is often to select the intended range and use Set Print Area to replace the collection with one clear boundary.

Change or remove a print area

To change the boundary, select the new complete range and choose Page Layout > Print Area > Set Print Area. This replaces the existing area on the active worksheet. To remove the saved boundary altogether, choose Page Layout > Print Area > Clear Print Area. With no print area set, Excel generally uses the worksheet’s used content when preparing a printout, subject to print settings and page layout.

Clearing a print area does not erase worksheet content or undo other page setup choices such as orientation, margins, or scaling. It only removes the saved range restriction. If a workbook has several sheets with their own print areas, clear or change the area on each sheet that needs adjustment; the command applies to the active sheet.

You can also inspect the saved range in desktop Excel’s Name Manager. Choose Formulas > Name Manager and look for the print-area name associated with the relevant sheet. Excel manages this name for printing; most users do not need to edit it directly. Setting or clearing the area through the Page Layout ribbon is less error-prone than changing the name manually.

Fit the print area to pages

A correct print area can still produce an awkward printout if it spans too many pages or shrinks to unreadable text. In Page Layout, set the paper size, orientation, and margins to suit the content. A wide table may fit better in landscape orientation, while a narrow list often works well in portrait. Use File > Print to check whether the page count and text size are acceptable.

Excel’s scaling controls can help fit a report to a chosen page width or height. In the Page Layout tab, the Scale to Fit controls let you adjust width and height; setting a width of one page can keep all columns together, while leaving height automatic allows the rows to flow onto multiple pages. Fitting both width and height to one page can make a large table extremely small, so do not assume fewer pages always means a more readable result.

Page breaks are another part of the layout. Excel inserts automatic breaks based on paper size, margins, and scaling. To view or adjust breaks, choose View > Page Break Preview. Dragging a break can change where the printout divides, but it does not change the print-area boundary. After adjusting it, return to print preview to check the resulting pages.

If column headings need to repeat at the top of every printed page, set them separately using Page Layout > Print Titles. A print area determines which cells are included; Print Titles determines which selected rows or columns repeat across pages. Repeating a header row is especially helpful for long tables, but it does not replace setting the print area.

Check the preview and fix common problems

Use File > Print before sending a job to a printer. The preview shows the pages Excel plans to produce and lets you review the selected printer, paper settings, and page count. If the preview is wrong, return to the worksheet or Page Layout settings rather than relying on the printer to correct it.

  • Extra pages appear: Check whether the print area includes far-off cells, an unintended added range, or rows and columns that extend the report. Use Set Print Area on the intended range to replace the current area.
  • A needed column or heading is missing: Expand or reset the boundary to include it. A title located just above the selected cells will not be included merely because it looks visually connected.
  • The report prints too small: Review scaling. A one-page-wide setting is usually less restrictive than forcing both width and height to one page. Consider landscape orientation or narrower margins as alternatives.
  • Page breaks split a table awkwardly: Review the breaks in Page Break Preview, adjust the page setup, or change the print area if it includes unnecessary width or rows.
  • The preview does not match the sheet: Confirm that you are on the intended worksheet and that the workbook was saved after the print-area change. Also check for multiple print areas and sheet-specific settings.

Blank cells inside a rectangular print area can still occupy space in the layout, which may affect pagination. If the blank region is large, set a tighter area rather than expecting Excel to trim it exactly as a person would. Hidden rows and columns are generally not shown in the printed output, but review the preview when hidden content or complex layouts matter.

Print area versus printing a selection

A print area is best when the same part of a worksheet will be printed repeatedly. It is saved as part of the worksheet’s setup and is available the next time the workbook is opened. Printing a selection is better for a one-time extract when you do not want to change the saved print layout.

For a one-off print, select the desired cells and open File > Print. In the print settings, choose the option to print the selection, when available. This is a temporary print choice, not a replacement for setting a print area. If the same selection will be needed for recurring reports, a saved print area is usually more convenient.

Another option is to copy the report cells to a separate worksheet or workbook and print that copy. This can be useful when the report needs a substantially different layout, but it creates extra content to maintain. A print area keeps the report and supporting calculations together while controlling what appears on paper.

Frequently Asked Questions

How do I add a print area in Excel?
Select the cells, then choose Page Layout > Print Area > Set Print Area. Check the result through File > Print.

How do I add a second print area without replacing the first?
Select the additional cells and choose Page Layout > Print Area > Add to Print Area. Separate ranges may print as separate regions or pages, so confirm the arrangement in the preview.

How do I remove a print area in Excel?
On the relevant worksheet, choose Page Layout > Print Area > Clear Print Area. This removes the print boundary but leaves worksheet data and other page settings in place.

Does a print area apply to every worksheet?
No. Print areas are worksheet-specific. Set, change, or clear the range on each sheet that needs its own print layout.

Why is Excel printing more pages than expected?
The selected range may be too large, contain added nonadjacent areas, or be split by page setup and scaling. Review the print preview, confirm the print area, and check orientation, margins, scaling, and page breaks.

Can I set a print area in Excel for the web?
Excel for the web has fewer print-area and page-setup controls than desktop Excel. Open the workbook in Excel for Windows or Mac when you need to set or manage the saved print area.

Related

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.