To remove a print area in Excel for Microsoft 365 on Windows, select the worksheet, go to Page Layout > Print Area > Clear Print Area. This removes the saved print-area setting from that sheet; it does not delete worksheet data.
Clear a print area in Excel
Use the ribbon command when you want Excel to stop restricting print output to a previously selected range. The command applies to the active worksheet, so first check that you are on the sheet whose print settings you want to change.
- Open the workbook and click the relevant worksheet tab.
- Select the Page Layout tab on the ribbon.
- In the Page Setup group, open Print Area.
- Choose Clear Print Area.
The change takes effect immediately. You do not need to select the old print-area cells first. Open File > Print to check the updated preview, then save the workbook if you want the change to remain after closing it. Clearing the setting does not require a special keyboard shortcut; use the ribbon path above.
If the Print Area button is hard to spot, look among the page-layout controls rather than the Home tab. The button may appear as a dropdown, and its position can vary slightly if the ribbon is narrow or customized. Maximizing the Excel window or expanding the ribbon can make the Page Setup commands easier to see.
What an Excel print area controls
A print area is a range, or collection of ranges, that Excel is instructed to print for a worksheet. For example, a sheet may contain a report in A1:F35 and raw data in H1:Q500. Setting A1:F35 as the print area tells Excel to print the report rather than include the data table in the same sheet’s print output.
Print areas are worksheet-specific and are saved with the workbook. They affect printing and print preview, not what appears on the screen during ordinary editing. A set print area can also make a worksheet look as if rows or columns have disappeared when you inspect the print preview, even though those cells remain present in the grid.
When no print area is set, Excel determines the sheet content to include in a print job. That does not always mean only cells with visible text: cells with formatting or other content can influence the range Excel considers in use. If the preview still includes unwanted blank pages after clearing the print area, investigate page breaks, formatting, and the sheet’s used range rather than assuming the old print area is still active.
Clear versus reset or replace a print area
Clear Print Area removes the saved print restriction for the active worksheet. It does not erase cell contents, remove page numbers, restore default margins, or reset every print-related setting. Options such as orientation, paper size, scaling, margins, and repeating rows or columns are separate settings and may remain as they were.
That distinction matters if your goal is to make the printout look normal again. Clearing the area gives Excel more freedom over which sheet cells to include, but it will not necessarily undo a fit-to-page setting or a manual page break. Check those settings separately if the preview still looks compressed or split in an unexpected place.
If you want to use a different range rather than remove the restriction entirely, select the new cells and choose Page Layout > Print Area > Set Print Area. Setting a new area replaces the existing print area on that worksheet. For instance, if the old range is A1:F35 and the new report occupies A1:G42, select A1:G42 before setting the replacement.
You can also choose a range just for one print job rather than save it as the sheet’s print area. Select the cells, open File > Print, and choose the option to print the selection in the print settings. This is useful for a one-off excerpt; it does not serve as a permanent replacement for a saved print area.
Remove print areas from multiple sheets
The clear command acts on the active worksheet, not automatically on every worksheet in the workbook. If several sheets have saved print areas, clear them one by one. Click a sheet tab, use Page Layout > Print Area > Clear Print Area, then repeat for each sheet that needs changing.
For a workbook with many sheets, a quick check can prevent surprises: open File > Print, choose the relevant sheet in the workbook, and review its preview. A sheet that still shows only a small block may have its own print area, while another sheet may already print normally. Do not assume that clearing one tab changed the settings on the others.
Excel also lets you group worksheets by selecting multiple sheet tabs, but changing page-layout settings while sheets are grouped can apply changes to all selected sheets. If you use grouping, verify exactly which tabs are selected before making changes, then ungroup them by clicking a single sheet tab. For a simple cleanup, working on each sheet separately is less likely to change settings you did not intend to touch.
Check the result in Print Preview
After clearing the area, use File > Print to see what Excel now plans to print. Review every page in the preview, not just the first one. A large worksheet may produce many pages, and a content block that was previously excluded can now appear on later pages.
Use the print settings to confirm that Excel is printing the intended scope, such as the active sheet rather than the entire workbook. Also inspect orientation, paper size, margins, and scaling. For example, if a wide table now spans several pages across, changing orientation to landscape or adjusting scaling may help, but these are separate choices from removing the print area.
To inspect page boundaries on the worksheet itself, choose View > Page Break Preview. This view helps distinguish page breaks from a saved print area. A blue boundary or a manually adjusted page break can affect where pages divide, but it is not proof that a print area remains set. Return to View > Normal when you are finished checking.
Common problems and how to fix them
- The preview still shows only part of the sheet: Confirm you cleared the area on the correct worksheet. Then check the print settings for Print Selection, which can limit a print job independently of the saved print area.
- Extra blank pages appear: Look for stray formatting or content far below or to the right of the report, and review page breaks and scaling. Blank-looking cells can still affect the printable range.
- The page is still shrunk or split: Clearing the print area does not reset scaling or manual page breaks. Review the scaling choices in the Page Layout controls and inspect the sheet in Page Break Preview.
- Only one tab changed: This is expected when you run the command on one active sheet. Repeat it on each sheet that has a print area, or carefully group tabs only if you intend to change all of them.
- The setting returns after reopening: Save the workbook after clearing the area. If it was not saved, reopening the previous file can restore the earlier saved setting.
Excel stores a worksheet’s print-area information as a defined name, commonly shown as Print_Area in name-management tools. You usually do not need to edit that name directly: the ribbon command is the clearer way to remove it. If you inspect names because a workbook behaves unexpectedly, be mindful that names can have worksheet scope, so similarly named entries may apply to different tabs.
Windows, Mac, and Excel for the web
The steps above are for Excel for Microsoft 365 on Windows. In current desktop Excel for Mac, use the Page Layout tab and its Print Area menu, then choose Clear Print Area. Ribbon placement can differ by window size or Excel version, but the command has the same purpose. The Windows shortcut guidance does not apply as a special direct shortcut on Mac either; use the ribbon command.
Excel for the web has a more limited set of page-layout and print controls than the desktop application. If you cannot find a command for clearing a saved print area in the browser, open the workbook in the desktop app and use the steps above. In the web version, print options can still let you choose what to print for a particular job, but that is different from removing a persistent worksheet print-area setting.
If a colleague needs to print the workbook, save the change in the shared file and let them reopen or refresh the updated version. A local unsaved change will not update the copy another person has open.
Frequently Asked Questions
Does clearing a print area delete cells or data?
No. It removes the instruction that limits printing to a specified range. Cell values, formulas, formatting, and objects remain on the worksheet.
How do I remove a print area in Excel without deleting the worksheet?
Click the worksheet tab, then choose Page Layout > Print Area > Clear Print Area. The sheet itself and its contents stay in the workbook.
Why does Excel still print only the selected cells?
The print job may be set to print a selection, or you may be viewing a different worksheet from the one you cleared. Check the active sheet and the print-scope dropdown in File > Print.
Will clearing a print area change margins or page orientation?
No. Margins, orientation, paper size, scaling, and page breaks are separate page-setup settings. Change those independently if the preview needs further adjustment.
Can I clear print areas from the whole workbook at once?
The standard ribbon command clears the active sheet’s area. Repeat it on the other relevant sheets, taking care with grouped tabs because page-layout changes can affect every selected sheet.
Related
- How to Read a Heat Map in Excel and Spot Key Patterns
- How to Print a Selected Area in Excel on One Page Only
- How to Put a Heat Map in Excel Using Conditional Formatting
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Create a Signature Block in Microsoft OutlookTo create a signature block in Outlook, open the signature settings for your version, make a signature, and…
- Excel Power Query: Add Data to an Existing Table?Yes—use Power Query’s Append operation to combine rows from an existing table and another data source, then load…
- Conditional Formatting for Absolute Values in ExcelTo conditionally format values by their absolute size in Excel for Microsoft 365 on Windows, create a formula…
- Excel Undo Shortcut: Ctrl+Z and How It WorksIn Excel for Microsoft 365 on Windows, press Ctrl+Z to undo your most recent action; on a Mac,…
- How to Apply a Filter in Google Sheets: Narrow DataTo filter data in Google Sheets in a web browser, select your table, choose Data > Create a…
- Monthly Calendar in Google Sheets: How to Create OneTo create a monthly calendar in Google Sheets, enter the month’s first date in a cell such as…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.