Excel Set Print Area: Steps, Tips, and Fixes

How-to basics · Updated November 21, 2026

To set 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 as the worksheet’s print area, so it is used when you print or preview the sheet until you change or clear it.

What a print area does

A print area is the part of a worksheet Excel includes when printing that sheet. It helps keep notes, calculations, helper columns, or empty formatted cells off paper without deleting them. For example, a sales worksheet might contain a report in A1:F30 and a set of working calculations in H1:K30. Setting A1:F30 as the print area means the calculations remain available on screen but are not included in the sheet’s printed output.

The print area controls which cells are eligible to print; it does not decide by itself how many pages they occupy. Page size, margins, orientation, scaling, and manual page breaks also affect the result. A selected range that looks compact on screen can still span several printed pages if it is too wide or long for the chosen paper.

Print areas are worksheet-specific. Setting one on a report tab does not automatically set the same range on another tab. They are also different from hiding rows or columns: hidden cells are not normally printed, but they remain hidden in the worksheet, while a print area leaves all worksheet content visible and simply limits the printed portion.

Set a print area step by step

  1. Open the worksheet you want to print. If you have several tabs, make sure the correct sheet is active.
  2. Select the cell range to include. You can drag across the cells or click the first cell, hold Shift, and click the last cell of a rectangular range.
  3. On the ribbon, choose Page Layout > Print Area > Set Print Area.
  4. Open File > Print or press Ctrl+P to inspect the preview. Confirm that the expected cells appear and check how many pages Excel will print.

For example, if a formatted table runs from B2 to G26, select B2:G26 before setting the area. Selecting an extra blank column or row can affect scaling and page layout, particularly if that cell contains formatting or a value that extends the used range. If the preview is not right, return to the worksheet, adjust the selection or page settings, and preview again.

On Excel for Mac, the desktop workflow is also available from Page Layout > Print Area; use Command+P to open printing rather than Ctrl+P. When selecting separate ranges on a Mac, use the Command key where Windows instructions use Ctrl. Excel for the web can print sheets, but use the desktop app when you need to create or change a saved print area.

Add more cells or separate ranges

If a print area already exists and you want to extend it, select the additional cells and choose Page Layout > Print Area > Add to Print Area. This adds the selection to the existing print area. By contrast, choosing Set Print Area again makes the current selection the print area and replaces the previous one. That difference is a common source of confusion when a previously included block disappears.

You can also select nonadjacent ranges by holding Ctrl on Windows while selecting each range, then use Set Print Area. Excel treats the selected blocks as separate print areas. They can be printed separately rather than being joined into one continuous rectangular block, so check the preview to see the resulting page arrangement. Separate areas are useful for printing two small report tables without including the columns between them, but they may not fit together on one page as a single table would.

When multiple blocks should appear together in a particular layout, consider placing them in adjacent cells on a report sheet instead. A print area identifies cells; it does not rearrange them or remove the blank gap between disconnected parts of the worksheet.

Fit the print area to the page

After choosing what to print, adjust how it fits. On the Page Layout tab, set Orientation to Portrait or Landscape and choose an appropriate paper size. Landscape can help with a wide table, but it does not guarantee that the text will remain readable. Use Margins to control whitespace around the page.

For a table that must fit on a known number of pages, use the Scale to Fit controls on the Page Layout tab. You can set the width or height to a page count; for instance, setting width to 1 page can keep a wide report from being split across several pages horizontally. Setting both width and height to 1 page forces the entire print area onto one page, which may shrink a large worksheet to an unreadable size. A better choice for a long report is often one page wide with the height left automatic, so rows continue onto additional pages at a usable scale.

Another option is the Page Setup dialog, opened from the small dialog launcher in the Page Layout tab’s Page Setup group. Its Page tab includes scaling options, while its Margins and Sheet tabs contain related settings. If the output looks crowded, try a different orientation or paper size before reducing the scale dramatically.

Preview pages and control page breaks

Use File > Print (or Ctrl+P on Windows) to see the print preview before sending a job to a printer or saving a PDF. Review every page, not just the first one: a heading may be stranded at the bottom of one page, or a final column may have been pushed onto another. The preview also lets you confirm the selected printer, paper size, and print settings.

For a worksheet-level view of page divisions, choose View > Page Break Preview. This view shows how the content is divided into pages and lets you adjust page breaks by dragging them. It is useful when a print area is correct but the split between pages is awkward. A print area and page breaks serve different purposes: the area sets the outer boundary of printable cells, while page breaks determine where those cells divide across pages.

If a title row needs to repeat on each printed page, set it separately through Page Layout > Print Titles. Choose rows to repeat at the top (or columns to repeat at the left) in the Page Setup dialog. Repeating titles is not the same as expanding the print area; it controls repeated labels on pages within the printout.

Change or clear a print area

To replace an existing area, select the new range and choose Page Layout > Print Area > Set Print Area. To remove the saved boundary, choose Page Layout > Print Area > Clear Print Area. Clearing it does not delete worksheet cells or undo formatting; it removes the print-area restriction, allowing Excel’s normal print behavior to include the sheet’s printable content.

If you only need a one-time print of a different range, you may not need to change the saved area. In File > Print, use the Settings menu and choose Print Selection after selecting the cells. This is convenient for a quick extract, but it is not a replacement for setting a persistent print area when the same report will be printed repeatedly.

Common problems and practical fixes

  • The wrong cells appear: Check that the intended sheet is active and inspect the selection before choosing Set Print Area. Selecting a new area replaces the old one; use Add to Print Area when you mean to extend it.
  • Blank pages appear: Look for an oversized print area, stray values, or formatting far from the report. Clear the area and set a tighter range, then check Page Break Preview and the print preview.
  • The text is tiny: Excel may be scaling too much content onto one page. Set only the width to one page, allow more pages vertically, or print on larger paper instead of forcing both dimensions to one page.
  • A column is cut off: Try Landscape orientation, narrower margins, or a smaller scale. Check the preview after each change; the best fix depends on the printer and paper size.
  • The old setting returns: A print area belongs to a worksheet and is saved with the workbook. Confirm that you changed the right sheet and save the workbook after editing it.
  • The printout has no repeated headings: Set Print Titles separately. Selecting a print area alone does not repeat a header row on later pages.

Also distinguish between a print area and a printer’s printable margins. Even if the cells fit within the worksheet’s page layout, a physical printer may not print right to the paper’s edge. If the preview differs from the paper output, verify the printer’s paper size and margin capabilities.

Saving, sharing, and choosing the right method

A print area is part of the workbook’s worksheet setup, so save the file if you want the setting to be available later or to travel with the workbook. When someone else opens the file in desktop Excel, they can review or change the print area on that sheet. If you are sharing a report that must look consistent, also check orientation, paper size, scaling, and print titles rather than relying on the range alone.

Choose a saved print area for a recurring report, such as a monthly summary that always uses the same cells. Choose Print Selection for a one-off extract. Use a separate report worksheet when the material to print is scattered across a complicated working sheet or needs a carefully arranged layout. These approaches solve different needs: setting an area is quick and preserves the existing worksheet, while a dedicated report sheet provides more control over presentation.

Frequently Asked Questions

How do I set a print area in Excel?

Select the cells, then choose Page Layout > Print Area > Set Print Area. Open File > Print to confirm the range and page layout.

How do I remove a print area in Excel?

On the worksheet with the area, choose Page Layout > Print Area > Clear Print Area. This removes the restriction without deleting any cells.

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

Yes. Select nonadjacent ranges using Ctrl while selecting on Windows, then set the print area. Excel treats the ranges as separate areas, so preview the pages to verify how they will print.

Why is Excel printing blank pages?

The print area may include extra rows or columns, or distant cells may affect the print layout. Set a tighter range and check Page Break Preview and File > Print for unexpected page divisions.

Does setting a print area make the worksheet fit on one page?

No. It limits which cells are included, but page count depends on scaling, paper size, orientation, margins, and page breaks. Adjust those settings separately if you need a particular page layout.

Can I set a print area in Excel for the web?

For creating or changing a saved print area, open the workbook in desktop Excel. Excel for the web has printing options, but the desktop app provides the Print Area commands described here.

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.