How To Set And Clear A Print Area In Excel (2026)

A print area tells Excel to print only the part of a worksheet you choose instead of the whole sheet.

It is the quickest way to stop extra columns, notes or scratch calculations from landing on paper.

This guide follows Microsoft’s support pages and covers setting, adding to and clearing a print area, plus the page break and page setup options that go with it.

Quick answer: print area commands

TaskWhere to go
Set a print areaSelect the cells, then Page Layout > Page Setup > Print Area > Set Print Area
Add cells to itSelect the cells, then Page Layout > Print Area > Add to Print Area
Clear itClick anywhere on the sheet, then Page Layout > Print Area > Clear Print Area
Check every print areaView > Workbook Views > Page Break Preview
Type the range by handPage Layout > Page Setup launcher > Sheet tab > Print area

Set a print area

  1. Select the cells you want to print.
  2. Go to the Page Layout tab.
  3. In the Page Setup group, select Print Area.
  4. Select Set Print Area.

After you define a print area, only that area prints when you print the sheet.

Microsoft notes that the print area is saved when you save the workbook.

Set more than one print area

Hold down Ctrl and click or drag each area you want before you choose Set Print Area.

Each area prints on its own page.

Use Page Break Preview on the View tab to check all of the print areas at once.

Add cells to an existing print area

  1. Select the cells you want to add.
  2. On the Page Layout tab, select Print Area in the Page Setup group.
  3. Select Add to Print Area.

You can only add adjacent cells to the existing area.

If the cells are not adjacent, Excel creates a separate print area for them, and that area prints as its own page.

Clear a print area

  1. Click anywhere on the worksheet.
  2. On the Page Layout tab, select Clear Print Area in the Page Setup group.

If the sheet has several print areas, clearing removes all of them.

Once the print area is cleared, the entire worksheet prints again.

Set the print area in the Page Setup box

You can also type the range instead of selecting it.

  1. On the Page Layout tab, select the Dialog Box Launcher in the Page Setup group.
  2. Open the Sheet tab.
  3. Click the Print area box and type the range, or drag across the cells on the sheet.

The Collapse Dialog button next to the box lets you select cells on the worksheet more easily.

What else the Sheet tab controls

OptionWhat it does
Rows to repeat at topRepeats chosen rows as titles on every page
Columns to repeat at leftRepeats chosen columns as titles on every page
GridlinesPrints the cell gridlines, which are off by default
Black and whitePrints in grayscale on a color printer
Draft qualityPrints faster at lower quality if the printer supports it
Row and column headingsIncludes the row numbers and column letters in the printout
Comments and notesNone, At end of sheet or As displayed on sheet
Cell errors asDisplayed, blank, a double hyphen or #N/A
Page orderDown, then over, or Over, then down

Microsoft says gridlines are not printed by default, whether or not they are visible on the worksheet.

Page tab settings that change how the area fits

SettingWhat it does
OrientationSwitches between portrait and landscape
Adjust toPrints at a percentage of normal size
Fit toSets how many pages wide and tall the area spans
Paper sizeLetter, Legal or another size
First page numberAuto starts at 1, or enter a number

To fit the width on one page and let the height run as long as needed, enter 1 in the wide box and leave the tall box empty.

Adjust margins and centering

The Margins tab in the same Page Setup box sets how much blank space surrounds the print area.

SettingWhat it does
Top, Bottom, Left, RightThe distance between your data and the edge of the page
Header and FooterThe distance from the top or bottom edge, which should be smaller than the margins so they do not overlap the data
Center on pageCenters the data horizontally, vertically or both

The Preview box on that tab shows the effect of each margin change before you print.

Control where pages break

Page Break Preview shows automatic breaks as dashed lines and manual breaks as solid lines.

TaskSteps
Turn on the previewView > Workbook Views > Page Break Preview, or the status bar button
Insert a breakSelect the row below or the column to the right, then Page Layout > Breaks > Insert Page Break
Remove a manual breakSelect the cell next to the break, then Page Layout > Breaks > Remove Page Break
Remove all manual breaksPage Layout > Breaks > Reset All Page Breaks
Return to the normal viewView > Workbook Views > Normal

You cannot delete an automatic page break, and moving one turns it into a manual break.

If your manual breaks do nothing, the Fit to scaling option may be selected, so switch the Page tab to Adjust to.

If the print area is not working

ProblemWhat to check
The whole sheet still printsA print area may not be set, or you cleared it; set it again from Page Layout
An extra page printsYou may have two separate print areas, which each print on their own page
Page breaks cannot be draggedTurn on File > Options > Advanced > Enable fill handle and cell drag-and-drop
Dotted page break lines remain in Normal viewClear Show page breaks under File > Options > Advanced

Official sources

Leave a Reply

Your email address will not be published. Required fields are marked *