Cannot change print area in excel 2010 how to#

However, if you do have multiple print areas and they arenРІР‚в„ўt connected to one another, they will print on separate pages. You can have multiple print areas in Excel.

You can set a print area if you highlight the cells that you want to print, go the Page Setup group, click Print Area, then choose the Set Print Area option.Р”Р„dditionally, if you would like to add more cells to an existing print area you can do so by choosing those cells, selecting the Page Layout tab, then clicking the Print Area button and selecting the Add to Print Area button. 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. Step 2: Click the Page Layout tab at the top of the window. Step 1: Open the Excel document with the set print area that you want to clear. But when that print area changes and you need to remove the settings, you can clear the print area in Excel 2010. 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.

Cannot change print area in excel 2010 how to#

How to Stop Excel 2010 From Printing a Specified Print Area (Guide with Pictures)Р”Вesignating 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.

Our article continues below with additional information on clearing the print area in Excel, including pictures of these steps.

Select the Page Layout tab at the top of the window.

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.Р”Тђ Additional Sources How to Clear Print Area РІР‚вЂњ Excel 2010 Unfortunately, while the print area is set, that is the only range of cells that you will be able to print. 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. Microsoft Excel 2010 allows you to customize most aspects of your spreadsheet, including the way that it prints. Fortunately, you can use a similar process to remove a print area from your Excel spreadsheet if you donРІР‚в„ўt need it anymore. But occasionally a print area has been set and is no longer correct. Print areas in Microsoft Excel are a good solution when you need to print some of the data in a file, but not all of it.