Excel Print Area: How to Fix It and Print the Right Cells

To fix an Excel print area, select the cells you want on paper, then choose Page Layout > Print Area > Set Print Area. If Excel is still printing the wrong cells, clear the old print area first with Page Layout > Print Area > Clear Print Area, then select the correct range and set it again. Check File > Print before printing.

What You’ll Need

The Excel workbook and worksheet you want to print, opened in the desktop version of Excel for Microsoft 365 on Windows.
A printer, or access to Print Preview, so you can confirm the result before using paper.
The range of cells you want to appear in the printout. If you are unsure, identify its first and last rows and columns before setting the area.

A print area is a saved worksheet setting that tells Excel which cells to include when you print that sheet. You do not need to select the cells every time once the area is set. The saved setting can also be the reason an old or unexpected range keeps appearing.

Step-by-Step

Open the correct worksheet. Click the sheet tab that contains the information you want to print. Print areas belong to individual worksheets, so a correct setting on one tab will not automatically apply to another. If the workbook has several similar tabs, check the tab name and visible data before changing anything.
Check what Excel currently plans to print. Choose File > Print, or press Ctrl+P on Windows. Look at the preview and note whether Excel is printing too many cells, omitting part of the table, or splitting the output unexpectedly. Use the back arrow to return to the worksheet without printing. Previewing first helps distinguish a wrong print area from a page-layout or scaling problem.
Clear an old print area if the range is wrong. On the worksheet, open the Page Layout tab, select Print Area, and choose Clear Print Area. This removes the saved print range for the active sheet; it does not delete any cell contents or formatting. Clearing first is useful when you do not know how the current area was defined, or when a workbook has been reused and its print settings no longer match the data.
Select the exact cells you want included. Click the first cell, then drag to the last cell in the rectangular range. You can also click the first cell, hold Shift, and click the last cell. For a large range, use the Name Box to the left of the formula bar: enter a range such as A1:G35 and press Enter. Make sure you include all required headings, totals, notes, and the last column; anything outside the selection will not be part of the print area.
Set the new print area. With the desired range selected, choose Page Layout > Print Area > Set Print Area. Excel outlines the selected cells with a print-area boundary on the worksheet. The boundary may be subtle in Normal view, so use Page Break Preview or Print Preview to verify the range. The setting is associated with this worksheet and is saved with the workbook.
Review the print preview again. Press Ctrl+P or choose File > Print. Check that the preview shows the right information, including the first and last rows and columns. If the area is correct but the content is too small or spans too many pages, do not keep changing the print area unnecessarily; adjust page orientation, margins, or scaling instead. Return to the sheet to make those changes.
Adjust page layout if the range does not fit well. On Page Layout, try Orientation > Landscape for a wide table, or choose Margins to reduce unused space. In the Scale to Fit group, review Width and Height; setting Width to 1 page can fit columns across one page, but may shrink text significantly. Use Print Preview after each adjustment, because fitting both width and height to one page can make a large report difficult to read.
Print or save the workbook. When the preview is right, choose the printer and print settings in File > Print, then print the sheet. Save the workbook if you want the print area to remain available next time. If you are preparing several sheets, check each one separately because each worksheet can have its own print area and page setup.

If you need to print a one-time range without changing the workbook’s saved print area, select the cells and use File > Print. In the print settings, choose Print Selection if that option is available. This is different from setting a print area: a print selection is for the current print job, while a print area remains a worksheet setting.

Common Mistakes

Setting the new range without clearing the old one. If the printout still includes an unrelated block or ignores your intended range, clear the existing area and set the correct range again. A saved range can be difficult to spot when the sheet contains lots of data.
Selecting only the visible part of a table. It is easy to leave out a totals row, a title, or the final column. Check the address in the Name Box before setting the area, then check the preview from the first page through the last.
Confusing print area with page breaks. A print area defines which cells are eligible to print. Page breaks divide that area across pages. If all the intended cells are present but the pages break in awkward places, adjust page breaks or scaling rather than redefining the range.
Using Print Selection when you want a persistent setting. Print Selection applies to the current job and does not replace a saved print area. Conversely, setting a print area is unnecessary for a one-time print when Print Selection does exactly what you need.
Expecting separate selections to become one continuous table. If you add nonadjacent ranges to a print area, Excel may print each area separately, often on separate pages. For a single continuous report, select one rectangular range that includes the cells between the sections, or arrange the content together first.
Assuming a fit-to-page setting fixes a wrong range. Scaling changes the size of the selected print content; it does not decide which cells belong in the print area. Fix the range first, then adjust scaling if needed.

Tips

Use Page Break Preview to see the printable layout. Choose View > Page Break Preview. The view shows page boundaries and can help reveal whether a column or row falls onto an extra page. Return to View > Normal when you are done inspecting the layout.
Check the active sheet before changing the setting. If several worksheet tabs are selected together, Excel may apply certain layout changes to the grouped sheets. Click a single sheet tab before setting or clearing its print area, and check for a grouped-sheet indicator in the title bar.
Think about readability before forcing one-page output. A landscape page or narrower margins may be enough for a slightly wide table. If you set both width and height to one page for a long report, the font may become too small. A readable two-page printout is often more useful.
Use print titles for repeated headings. A print area controls which cells are printed, but it does not automatically repeat column headings on every page. To repeat rows at the top, use Page Layout > Print Titles and set Rows to repeat at top in the Page Setup dialog. Preview the result to ensure the repeated headings do not crowd the content.
Keep the saved workbook as the source of truth. If a colleague says the print area is wrong, confirm that they opened the latest saved copy. A modified but unsaved setting will not be present in the version they receive.

Troubleshooting

The preview still shows the wrong cells: Return to the intended worksheet and choose Page Layout > Print Area > Clear Print Area. Select the target range again, set the print area, and reopen File > Print. Also check whether the print settings are set to print the active sheet, the entire workbook, or a selection; those choices can change what is sent to the printer.

Some rows or columns are missing: Check the print-area boundary and compare it with the intended range. If necessary, clear and recreate the area using the Name Box to select an explicit address. Also check whether rows or columns are hidden or filtered out. Hidden content may not appear as expected, even when the surrounding range is included; unhide the needed rows or columns, or adjust the filter, then inspect the preview again.

The range is correct, but the printout is split across too many pages: Choose Page Layout > Orientation and test Landscape for a wide sheet. Review margins and the Scale to Fit controls, and inspect the page breaks in View > Page Break Preview. Avoid shrinking a large worksheet to one page if that makes the text too small to read. Adjust page breaks or print only the relevant columns if that produces a clearer result.

The print area menu is unavailable or changes do not stick: Confirm that you are editing the workbook in desktop Excel and that the worksheet is not protected in a way that prevents page setup changes. Save the workbook in a format that supports Excel worksheet settings, such as .xlsx, and try again. Excel for the web has a more limited page-layout experience; open the file in the desktop app to create or reliably edit a saved print area. In the web version, use its print options for a one-time print where available.

You are using Excel for Mac: The ribbon layout and some dialog details can differ, but the print-area commands are on the Page Layout tab under Print Area. Use Command+P rather than Ctrl+P to open printing on a Mac. In Excel for the web, keyboard shortcuts and menu placement can differ by browser; use the on-screen print controls or open the workbook in desktop Excel for the full worksheet setup.

Frequently Asked Questions

How do I remove a print area in Excel?
Open the worksheet, choose Page Layout > Print Area > Clear Print Area, and check File > Print. This removes the saved print area from that sheet without erasing cell data.

Can I set more than one print area on a worksheet?
Yes. Select one range, then hold Ctrl on Windows while selecting another nonadjacent range and use Page Layout > Print Area > Set Print Area. Separate areas may print on separate pages, so check the preview. On Mac, use Command when selecting nonadjacent ranges.

Why does Excel print blank pages after my table?
An oversized or stale print area, formatted cells far below the table, or page breaks can create extra pages. Clear and reset the print area to the actual table, then check Page Break Preview and Print Preview.

Does Excel remember the print area?
Yes. A print area is saved with the worksheet in the workbook. Save the file after changing it. Each sheet has its own setting, so changing one sheet does not automatically change the others.

How can I print the whole sheet after setting a print area?
Clear the print area before printing, or select the option to print the entire sheet in File > Print if it is available in your Excel version. Check the preview to confirm that the saved area is not limiting the result.

Can I change a print area in Excel for the web?
For dependable control over a saved print area, open the workbook in desktop Excel and use Page Layout > Print Area. The web version may offer print options for a current selection, but its page-layout controls are more limited.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.