Excel Set Print Area Not Working? Fix the Common Causes

If Excel’s print area is not working, select the intended cells and choose Page Layout > Print Area > Set Print Area, then check File > Print to see what Excel will output. If the preview is still wrong, the usual causes are a different print setting, an old or sheet-specific print area, or page layout settings that change how the area fits on paper.

What a print area controls

A print area tells Excel which worksheet cells to include when you print that sheet. It is saved with the workbook and applies to one worksheet at a time. It does not set the paper size, margins, orientation, or scale; those settings determine how the selected cells are arranged on printed pages.

The range is fixed until you change or clear it. For example, if your report occupies A1:F35 and you set that as the print area, information you later add in row 36 or column G will not automatically become part of the range. Select the expanded range and set it again, or use Add to Print Area if you want to preserve an existing area and include another one.

Also distinguish a print area from the cells that appear on screen. A worksheet can contain hundreds of rows and columns, but only its print area is included when Excel prints the active sheet with the normal print setting. Conversely, selecting Print Selection in the print options tells Excel to print the cells selected at that moment rather than relying on the usual sheet print setup.

Set the area again and remove old settings

Start by resetting the range on the worksheet that is giving you trouble. On Excel for Microsoft 365 on Windows:

Click the worksheet tab you intend to print. If several tabs are selected, click a single tab to ungroup them before making changes.
Select the exact cells, such as A1:F35. Drag across the range or click the first cell, then hold Shift and click the last cell.
Choose Page Layout > Print Area > Set Print Area.
Choose File > Print and inspect the preview before sending the job to a printer.

If you are unsure whether an old range is interfering, choose Page Layout > Print Area > Clear Print Area first. Then select the intended range and set it again. Clearing the area does not delete worksheet data; it removes the print-area instruction for that sheet. If you want to include a second, separate block without replacing the first, select the second block and choose Page Layout > Print Area > Add to Print Area.

Nonadjacent ranges can be selected with Ctrl held down on Windows, then set as one print area. Excel treats separate areas as separate print blocks, which can result in separate pages. If the output is awkward, a single rectangular range with blank cells between sections may be easier to control.

Check what Excel is actually set to print

In File > Print, look at the print-scope control as well as the preview. Print Active Sheets is the normal choice when you want the current worksheet or selected worksheet tabs. Print Entire Workbook includes all worksheets. Print Selection uses the cells currently selected. Choosing the wrong option can make a correct print area appear to have no effect.

For example, suppose A1:F35 is the print area, but you select H1:J10 before opening the print screen. If the print setting is Print Selection, Excel may preview H1:J10 instead of the report. Return to the sheet, select the intended cells if you mean to print a selection, or switch the print scope back to Print Active Sheets to use the sheet’s normal print setup.

Look at the preview page count and page boundaries. A preview showing unexpected blank pages, only a corner of the report, or extra columns often reveals whether the problem is the selected range, a different worksheet, or page layout rather than the print-area command itself.

Fix scaling, orientation, margins, and page breaks

A print area can be correct while the printed result looks wrong because the content is too wide, too small, or split across pages. In Page Layout, review Orientation, Size, and Margins. For a wide report, Landscape orientation or a larger paper size may help. In the Scale to Fit controls, setting Width to 1 page can keep the columns together; leaving Height set to Automatic lets the rows continue across multiple pages. Fitting both width and height to one page can shrink a long report until its text is difficult to read.

Manual page breaks can also split a printout in unexpected places. Choose View > Page Break Preview to see the page divisions. If you want to remove manual page breaks and let Excel paginate again, choose Page Layout > Breaks > Reset All Page Breaks. Check File > Print again afterward, because resetting breaks changes page divisions, not the print-area range.

Hidden rows and columns are generally not printed, even when they fall inside the print area. Filtered-out rows are likewise omitted from the visible printout. If expected data is missing, check for hidden rows or columns and active filters before expanding the area. If unwanted material appears, inspect the range boundaries and any visible content at the edges.

Make sure you are on the right worksheet

Each worksheet can have its own print area. Setting A1:F35 on one sheet does not set the same area on another. When printing the entire workbook, each sheet uses its own print setup, so a workbook can produce very different page counts from tab to tab.

Check the worksheet tab before setting or clearing an area. If multiple sheet tabs are grouped, Excel applies many layout changes to all selected sheets. The tabs are usually visibly highlighted when grouped. Right-click a selected tab and choose Ungroup Sheets, or click an unselected sheet tab, before adjusting only one sheet. This prevents an unintended change across several worksheets.

Another easy mix-up is printing a different sheet from the one you just configured. Use File > Print and confirm the preview corresponds to the correct tab. When printing multiple sheets, review each sheet’s layout rather than assuming one print area controls the whole workbook.

Inspect the saved print-area name

Excel stores a worksheet’s print area as a defined name, commonly displayed as Print_Area. If the ribbon commands do not seem to match the range, choose Formulas > Name Manager and look for Print_Area. Check its Refers to range and the sheet scope. A range that points to old rows or columns can explain why new content is missing.

Most users should fix the range with Page Layout > Print Area rather than editing names directly. If a workbook has been copied, heavily edited, or assembled from templates, the Name Manager can help identify a stale or unexpected reference. Make changes cautiously: other defined names may support formulas, charts, or other workbook features, and they are not print areas.

Separate print-area problems from printer problems

Use the File > Print preview to determine whether Excel has selected the right cells. If the preview is correct but a physical print is cropped, shifted, or scaled differently, investigate the printer and its driver settings. Check that the paper size selected in Excel matches the paper loaded in the printer, and review options such as scaling or borderless printing in the printer’s own dialog.

As a practical comparison, choose Microsoft Print to PDF in the Windows printer list and save a PDF. If the PDF matches the preview but the paper copy does not, the print area is unlikely to be the cause; focus on the printer configuration, paper, or driver. If the PDF is also wrong, return to the worksheet’s range and page setup. This test helps separate workbook layout from device-specific output.

Excel for Mac and Excel for the web

In Excel for Microsoft 365 on Mac, use the Page Layout tab and its Print Area controls to set or clear the range; ribbon labels and dialog placement can vary slightly from Windows. The common print shortcut is Command+P on Mac, compared with Ctrl+P on Windows. On Windows, Ctrl-click selects additional nonadjacent cells; on Mac, use Command-click for additional selections.

Excel for the web has different printing and layout capabilities from the desktop application. If you cannot find the print-area controls or need to inspect a workbook’s detailed page setup, open the file in the Excel desktop app and set the area there. In the web app, use the available print options and preview to check the output rather than assuming every desktop page-layout feature is available in the browser.

Frequently Asked Questions

Why does Excel print the whole worksheet instead of my print area?
Check File > Print and confirm that the scope is Print Active Sheets, not Print Entire Workbook or Print Selection. Then confirm that the intended worksheet has a print area set and that you are printing that sheet.

Why are new rows missing from my printout?
Print areas do not reliably expand just because you type below or beside them. Select the enlarged range and choose Page Layout > Print Area > Set Print Area, or use Add to Print Area when you want to keep the existing area and add another block.

How do I remove a print area without deleting cells?
Go to the affected worksheet and choose Page Layout > Print Area > Clear Print Area. The worksheet data remains; Excel simply stops using that defined print range.

Why does my print area create extra pages?
The range may be larger than the paper can hold at the current scale, or it may include multiple nonadjacent blocks. Review File > Print, orientation, paper size, margins, scaling, and page breaks. Try fitting the width to one page if keeping columns together is the priority.

Does each worksheet have its own print area?
Yes. A print area applies to an individual worksheet. Set or clear it on each sheet that needs different print boundaries, and review the preview for every sheet when printing the entire workbook.

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.