Excel guide · 6 min read
Excel print area not working: why it prints the wrong cells and how to fix it
Still not working on your sheet? Paste your cells and the formula into Cellwise Fix. The engine shows which cause it is on your data, then you get the fix, checked. Open Cellwise Fix
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C | D | E | F | G | H | I |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Region | Rep | Orders | Revenue | Target | % of target | Last row with data | 11 | |
| 2 | North | Amira | 48 | 61200 | 58000 | 1.0551724138 | Range to print | A1:F11 | |
| 3 | North | Ben | 39 | 47850 | 52000 | 0.92019230769 | Rows of data | 10 | |
| 4 | South | Chloe | 55 | 70400 | 65000 | 1.0830769231 | |||
| 5 | South | Dev | 31 | 36900 | 45000 | 0.82 | |||
| 6 | East | Erin | 44 | 52800 | 50000 | 1.056 | |||
| 7 | East | Farid | 50 | 63500 | 60000 | 1.0583333333 | |||
| 8 | West | Grace | 36 | 41400 | 48000 | 0.8625 | |||
| 9 | West | Hugo | 42 | 55020 | 52000 | 1.0580769231 | |||
| 10 | Central | Isla | 47 | 58750 | 55000 | 1.0681818182 | |||
| 11 | Central | Jonas | 29 | 33350 | 40000 | 0.83375 |
Download this sheet as an Excel practice file (.xlsx)
Quick checks
A print area is a range you tell Excel to print instead of the whole sheet. It's saved with the workbook, it belongs to one sheet, and it doesn't move or grow on its own. Most "print area not working" problems come from one of those three facts. The sample is a 10-rep sales report in A1:F11 that should print on one page.
- Excel prints the whole sheet even though a print area is set? Ignore Print Area is ticked, or Print Selection is chosen (causes 1 and 2).
- New rows at the bottom don't print? The print area is still the old range (cause 3).
- Parts of the sheet print on separate pages? There are several print areas (cause 4).
- Blank pages come out after your data? Something lives further down or to the right (cause 5).
- The right cells print but across too many pages? That's scaling and page breaks, not the print area (cause 6).
- Another sheet prints the wrong range? Each sheet has its own print area (cause 7).
1. Ignore Print Area is ticked
In the Print screen there's a switch that tells Excel to skip the print area and print the whole sheet. Microsoft's own instructions point to it: if a sheet has a print area, Excel prints only that area unless you select Ignore print area.
If it's ticked, your print area is still there, it just isn't being used. Untick it and the preview shrinks back to A1:F11.
- Press Ctrl+P (or File > Print).
- Under Settings, click the first box (it usually says Print Active Sheets).
- At the bottom of that list, click Ignore Print Area so it's no longer ticked.
- Check the preview on the right before you print.
2. Print Selection or Entire Workbook is chosen
The same Settings box decides what prints. Print Active Sheets uses each sheet's print area. Print Selection prints whatever cells are selected right now, so if A1 alone is selected you get one cell. Print Entire Workbook prints every sheet. If the preview looks wrong, check this box first.
If your report is an Excel table, Print Selected Table prints just the table without setting a print area: click any cell in the table, press Ctrl+P and choose it in the same box.
3. The print area is an old, fixed range
When you set a print area on A1:F8 and later add rows 9 to 11, those rows don't print. The print area is a fixed range: it doesn't expand when you add data below it, even inside a table. Excel stores it as a name called Print_Area, which you can see in Formulas > Name Manager.
To find how far the data goes now, use a formula that returns the last row with anything in it. Compare it with the print area shown in Page Break Preview. If they don't match, reset the print area.
- Select the full range you want to print (A1:F11 here).
- Go to Page Layout > Print Area > Set Print Area. This replaces the old area.
- Or, to extend it with cells right next to the current area, select those cells and use Page Layout > Print Area > Add to Print Area.
- To go back to printing the whole sheet, use Page Layout > Print Area > Clear Print Area.
Result: 11
11: the last filled row in A1:F40 is row 11, so the print area should be A1:F11. In older Excel versions, confirm this formula with Ctrl+Shift+Enter.
Can I type the print area instead of selecting it?
Yes. Page Layout > Page Setup dialog launcher (the small arrow in the group's corner) > Sheet tab > Print area box. A helper formula can build the address so you know what to type.
Result: A1:F11
A1:F11, the address to put in the Print area box.
4. Several print areas print on separate pages
If you hold Ctrl and select two ranges, then Set Print Area, you get two print areas. Each one always prints on its own page, and there's no setting to put them on the same sheet of paper. Add to Print Area does the same thing when the cells you add aren't touching the existing area: Excel creates a new print area instead of extending the old one.
Fixes: make the print area one block (hide the rows or columns in between if you don't want them on paper, since hidden rows and columns don't print), or copy the pieces onto a separate print sheet. Clear Print Area removes every print area on the sheet at once.
5. Blank pages after the data
Excel prints up to the last cell it thinks is used, and blank pages appear when that's far below or to the right of your report. Microsoft lists the usual causes: cells formatted to look empty (white font, or a custom ;;; format), errors set to print as blank, drawing objects or tiny shapes far away, and hidden columns with manual page breaks.
Press Ctrl+End to jump to the last used cell. If it lands on row 412 while the formula above says 11, rows 12 to 412 hold something. Select those rows, right-click > Delete (not just the Delete key, which leaves formatting behind), save the file, and check Ctrl+End again. Setting a print area on A1:F11 also stops the blank pages, because only the print area prints.
6. It prints the right cells, but on too many pages
The print area decides which cells print, not how many pages they take. If A1:F11 spills onto two pages, set the scaling: in the Print screen, change No Scaling to Fit Sheet on One Page or Fit All Columns on One Page. View > Page Break Preview shows the pages as blue outlines; drag a dashed break to the edge to fit more on a page. The full walkthrough is in print an Excel sheet on one page, and if the dotted break lines stay on screen afterwards, see page break lines won't go away.
7. Each sheet has its own print area
A print area belongs to one sheet. Setting it on the January sheet doesn't touch February, and copying a sheet copies its print area too, which is how a stale range spreads across a workbook. When you print several sheets at once (Print Entire Workbook, or grouped tabs), each sheet uses its own print area, or the whole sheet if it has none. Check each sheet in Page Break Preview before printing a batch. Gridlines are per sheet too: if they print on one sheet and not another, tick Page Layout > Gridlines > Print on each one (gridlines not showing covers screen and print).
Common mistakes
Setting the print area once and adding rows later
The range doesn't grow. Select the full range and use Set Print Area again, or Add to Print Area for cells right next to it.
Ctrl-selecting two ranges and expecting one page
Each print area prints on its own page. Make it one block and hide what you don't need.
Pressing Delete on stray rows to remove blank pages
Delete clears contents only. Right-click > Delete the rows so their formatting goes too, then save.
Leaving Ignore Print Area ticked
Untick it in the first box under Settings on the Print screen.
FAQ
Why does Excel print the whole sheet instead of the print area?
Ignore Print Area is ticked in the Print settings, or Print Entire Workbook or Print Selection is chosen. Press Ctrl+P, open the first box under Settings, untick Ignore Print Area and choose Print Active Sheets.
How do I reset the print area in Excel?
Select the range you want and click Page Layout > Print Area > Set Print Area; it replaces the old one. To remove it completely, use Clear Print Area on the same menu.
Why is my print area printing on multiple pages?
Either the sheet has several print areas, which always print on separate pages, or one area is too big for a page. Use one block, then choose Fit Sheet on One Page in the Print screen.
Does the print area update automatically when I add data?
No. It's a fixed range stored in a name called Print_Area. Set it again after adding rows, or use Print Selected Table if your data is an Excel table.
Functions used
Related guides
- How to print gridlines in Excel
- How to add a header in Excel
- Excel print titles not working: how to repeat the header row on every page
- How to add page numbers in Excel
- How to print an Excel sheet on one page
- DATEDIF not working in Excel: causes and fixes
Updated