How to Clear the Print Area in Excel 2010

Microsoft Excel 2010 allows you to customize most aspects of your spreadsheet, including the way that it prints. If you had previously set the print area for a document, then you know that you can force Excel to print out an area of cells that you have specified, regardless of whether there is information in those cells, or if there is additional information on the spreadsheet. Unfortunately, while the print area is set, that is the only range of cells that you will be able to print. So if you need to learn how to clear the print area in Excel 2010 because the designated print area is either no longer accurate, or because you want to print a different area of your spreadsheet, then you can follow the instructions below.


Stop Excel 2010 From Printing a Specified Print Area


Designating a print area in Excel 2010 is very helpful when you have a large spreadsheet and only periodically need to print a specific part of it. You do not need to remember to change your printer settings whenever you create a copy of the spreadsheet, and you can configure all of your page layout settings so that the spreadsheet prints to fit on a set number of pages. But when that print area changes and you need to remove the settings, you can clear the print area in Excel 2010.


Step 1: Open the Excel document with the set print area that you want to clear.

Step 2: Click the Page Layout tab at the top of the window.

excel 2010 page layout tab


Step 3: Click the Print Area drop-down menu in the Page Setup section of the ribbon at the top of the window, then choose the Clear Print Area option.

how to clear the print area in Excel 2010


If you want to print your spreadsheet and ignore a print area this one time, while still leaving it intact for future printings you can also choose the Ignore Print Area option on the Print menu.

ignore print area excel 2010


You can find this setting by clicking the File tab, clicking Print, clicking the Print Active Sheets drop-down menu, then choosing Ignore Print Area. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.