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
| Task | Where to go |
|---|---|
| Set a print area | Select the cells, then Page Layout > Page Setup > Print Area > Set Print Area |
| Add cells to it | Select the cells, then Page Layout > Print Area > Add to Print Area |
| Clear it | Click anywhere on the sheet, then Page Layout > Print Area > Clear Print Area |
| Check every print area | View > Workbook Views > Page Break Preview |
| Type the range by hand | Page Layout > Page Setup launcher > Sheet tab > Print area |
Set a print area
- Select the cells you want to print.
- Go to the Page Layout tab.
- In the Page Setup group, select Print Area.
- 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
- Select the cells you want to add.
- On the Page Layout tab, select Print Area in the Page Setup group.
- 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
- Click anywhere on the worksheet.
- 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.
- On the Page Layout tab, select the Dialog Box Launcher in the Page Setup group.
- Open the Sheet tab.
- 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
| Option | What it does |
|---|---|
| Rows to repeat at top | Repeats chosen rows as titles on every page |
| Columns to repeat at left | Repeats chosen columns as titles on every page |
| Gridlines | Prints the cell gridlines, which are off by default |
| Black and white | Prints in grayscale on a color printer |
| Draft quality | Prints faster at lower quality if the printer supports it |
| Row and column headings | Includes the row numbers and column letters in the printout |
| Comments and notes | None, At end of sheet or As displayed on sheet |
| Cell errors as | Displayed, blank, a double hyphen or #N/A |
| Page order | Down, 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
| Setting | What it does |
|---|---|
| Orientation | Switches between portrait and landscape |
| Adjust to | Prints at a percentage of normal size |
| Fit to | Sets how many pages wide and tall the area spans |
| Paper size | Letter, Legal or another size |
| First page number | Auto 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.
| Setting | What it does |
|---|---|
| Top, Bottom, Left, Right | The distance between your data and the edge of the page |
| Header and Footer | The distance from the top or bottom edge, which should be smaller than the margins so they do not overlap the data |
| Center on page | Centers 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.
| Task | Steps |
|---|---|
| Turn on the preview | View > Workbook Views > Page Break Preview, or the status bar button |
| Insert a break | Select the row below or the column to the right, then Page Layout > Breaks > Insert Page Break |
| Remove a manual break | Select the cell next to the break, then Page Layout > Breaks > Remove Page Break |
| Remove all manual breaks | Page Layout > Breaks > Reset All Page Breaks |
| Return to the normal view | View > 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
| Problem | What to check |
|---|---|
| The whole sheet still prints | A print area may not be set, or you cleared it; set it again from Page Layout |
| An extra page prints | You may have two separate print areas, which each print on their own page |
| Page breaks cannot be dragged | Turn on File > Options > Advanced > Enable fill handle and cell drag-and-drop |
| Dotted page break lines remain in Normal view | Clear Show page breaks under File > Options > Advanced |
Related Excel guides
- Fit an Excel sheet on one page when printing covers the scaling options in more detail.
- Repeat header rows on every printed page in Excel uses the same Sheet tab.
- Fix Word or Excel not printing in Windows 11 if the print job never starts.
Official sources
- Set or clear a print area on a worksheet (Microsoft Support)
- Page Setup (Microsoft Support)
- Insert, move, or delete page breaks in a worksheet (Microsoft Support)