Print Area in Excel: Set, Adjust, and Print a Worksheet

How-to basics · Updated November 18, 2026

To set a print area in Excel for Microsoft 365 on Windows, select the cells you want, then choose Page Layout > Print Area > Set Print Area. Excel will print that range instead of the entire worksheet; check the result with File > Print before printing.

What a print area does

A print area is a worksheet range Excel treats as the intended content for printing. For example, a worksheet might contain a monthly report in A1:F28, with notes, calculations, or a separate chart farther to the right. Setting A1:F28 as the print area keeps that extra material out of the printed report without deleting or moving any cells.

The setting belongs to a particular worksheet and is saved with the workbook. It does not change what is visible on screen, remove data, or prevent you from editing cells outside the selected range. It controls what Excel includes when you print that sheet, while other print settings determine details such as page size, margins, orientation, scaling, and page breaks.

A print area is useful when a sheet contains working data alongside a polished summary, when a form occupies only part of a page, or when you want a recurring report to print consistently. It is not the same as selecting cells and printing a one-time selection: a defined print area remains in effect until you change or clear it.

Set a print area step by step

On Windows, first select the cells that should appear in the printed output. You can drag across the range, or click the Name Box to the left of the formula bar, type a range such as A1:F28, and press Enter. Then use the Page Layout tab to define it:

  1. Select the worksheet and the exact range to print.
  2. Choose Page Layout > Print Area > Set Print Area.
  3. Open File > Print to inspect the print preview.
  4. If the preview is not right, return to the sheet and adjust the print area or page layout settings.

Use a range that includes the report’s headings as well as its data. If the first row contains a title and the first column contains names, for instance, selecting only the rows of figures can make the output difficult to interpret. Check for intended borders and notes too: a cell may look blank but still contain formatting that produces visible lines on paper.

Change, expand, or clear the print area

To replace the existing range, 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 worksheet. This is often the simplest fix when a report grows or the original selection included too many columns.

To keep the current print area and include another range, select the additional cells and choose Page Layout > Print Area > Add to Print Area. Excel can therefore use more than one print area on a sheet. Separate areas are printed as distinct areas, rather than being treated as one continuous block with all the intervening cells included. Review the preview because the resulting page arrangement may not match a single-table layout.

To remove the restriction and return to printing the worksheet’s used content, choose Page Layout > Print Area > Clear Print Area. Clearing the print area does not clear cell contents or formatting. If the menu command appears unavailable, first confirm that you are on the worksheet whose print area you want to change.

Print nonadjacent ranges and multiple sections

Some reports have separate blocks that should print but should not be joined by blank columns or rows. You can select nonadjacent ranges and set them as print areas, or add the sections one at a time with Add to Print Area. On Windows, hold Ctrl while selecting additional ranges. On a Mac, use Command while selecting nonadjacent ranges.

For example, a sheet might contain a summary in A1:D12 and a small assumptions table in G1:I6. Adding the second range can include both sections while leaving columns E and F out of the print areas. Excel may place those sections on separate printed pages, depending on their size and the page layout. Check each preview page, especially if the areas have different widths or one is much taller than the other.

If the sections need to appear together in a carefully designed order, a dedicated print sheet can be easier to manage. Copy or link the report sections onto that sheet, arrange them in one continuous layout, and set a single print area there. This avoids unexpected page placement and keeps the source data sheet unchanged.

Fit the print area to paper

Defining a print area determines which cells are eligible to print; it does not guarantee that the range will fit on one page. A wide table can still span several pages, and a long table may continue down multiple pages. Use the preview under File > Print to see the actual page count and how Excel divides the range.

For a wide report, try Page Layout > Orientation > Landscape. You can also choose a suitable paper size and adjust margins from the Page Layout tab. To scale the output, use the Width and Height controls in the Page Layout tab’s Scale to Fit group. Setting Width to 1 page can keep all columns together while allowing the rows to continue onto additional pages. Setting both Width and Height to 1 page forces the entire range onto one page, but may shrink text until it is hard to read.

Another option is the scaling control in File > Print, where you can choose a fit-to-page option. Scaling reduces or enlarges the printed content; it does not edit the worksheet’s cell sizes or font sizes. If the preview looks too small, use a larger paper size, landscape orientation, narrower margins, or a more selective print area rather than forcing a very large report onto one page.

Page breaks, headings, and repeated labels

Excel may divide a print area across pages using automatic page breaks. To inspect them, choose View > Page Break Preview. The view shows page boundaries; where Excel allows a break to be adjusted, you can drag it to change how the content is divided. Return to Normal view when you have finished reviewing the sheet.

For a table that continues across several pages, repeat its column headings so readers can identify each column on later pages. Choose Page Layout > Print Titles, then set rows to repeat at the top or columns to repeat at the left. This setting helps with multi-page output, but it does not replace a print area: the print area still defines the worksheet content to include.

For instance, if row 1 contains the table headings, set row 1 as the row to repeat at the top. Then inspect the preview to confirm the headings appear on each relevant page and that the data is not split in an awkward place. Repeated titles are particularly helpful for long lists, but repeating several rows can leave less room for data on each page.

Common print-area problems

  • Extra pages appear: The print area may include distant cells, or the selected range may be too wide or tall. Use Print Preview to identify the page containing the unexpected content, then reset the range.
  • Only part of the report prints: The print area may be smaller than the report. Select the full intended range and set it again, or use Add to Print Area for a separate section.
  • The printout is tiny: A fit-to-one-page setting may be shrinking a large range. Allow more pages, change orientation, or narrow the area.
  • Blank pages appear: Check the preview for stray formatted cells, distant content, or page breaks that extend the output. Clear or reset the print area and review the sheet’s page layout.
  • Filtered or hidden data is missing: Hidden rows and columns generally do not appear in printed output. Check whether rows are filtered or manually hidden if expected records are absent.

A common misconception is that an empty-looking worksheet cell cannot affect printing. Formatting, borders, or content far outside the visible report can affect the worksheet’s used extent or create unwanted output when no suitable print area is set. Preview the pages rather than relying only on the dotted page-break lines in Normal view.

Windows, Mac, and Excel for the web

The steps above use Excel for Microsoft 365 on Windows. In Excel for Microsoft 365 on Mac, the print-area commands are also on the Page Layout tab under Print Area; menu placement can vary slightly with the ribbon layout. Use Command+P to open printing on Mac. On Windows, the shortcut is Ctrl+P.

Excel for the web does not provide the same full print-area management commands as desktop Excel. For a one-time print, select the cells you need and use File > Print, then review the available selection and print options. If you need to save a print area in the workbook, add multiple defined areas, or adjust advanced page layout settings, open the workbook in the desktop app.

Regardless of platform, the preview is the practical final check. Printer drivers and paper settings can affect the output, so confirm the selected printer, paper size, orientation, and page count before sending a large report.

When to use a print area—and when not to

Use a print area when the same specific portion of a worksheet should be printed repeatedly, such as a standard monthly report or a form. It keeps the intended range defined in the workbook and makes normal printing less likely to include unrelated worksheet content.

For a one-off print, selecting cells and printing only the selection may be more convenient than changing a worksheet’s saved print area. For a report that needs a precise visual design, page numbers, consistent headers, or a different layout from the data sheet, consider creating a separate report sheet. These approaches are alternatives, not requirements: choose the one that makes the print workflow easiest to repeat and verify.

Frequently Asked Questions

How do I set a print area in Excel?
Select the cells, then choose Page Layout > Print Area > Set Print Area. Use File > Print to check the result.

How do I print only selected cells without saving a print area?
Select the cells and open File > Print. Choose the option to print the current selection if it is available in your Excel version. This is useful for a one-time job; it does not define a recurring print area.

How do I remove a print area in Excel?
On the relevant worksheet, choose Page Layout > Print Area > Clear Print Area. The command removes the print setting, not the worksheet data.

Can I set more than one print area on a worksheet?
Yes. Select another range and choose Page Layout > Print Area > Add to Print Area. Inspect the preview because separate areas may print as distinct sections or pages.

Why does Excel print my table on several pages?
The range may be larger than the paper can hold at its current scale. Change orientation or margins, adjust the Scale to Fit settings, or allow the table to span pages. Avoid fitting a large table onto one page if the resulting text is unreadable.

Does a print area change what other people see in the worksheet?
No. A print area affects printing, not the sheet’s on-screen contents. The range remains editable, and clearing the print area does not delete any cells.

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.