Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 If you print a specific selection on a worksheet frequently, you can define a print area that includes just that selection. A print area is one or more ranges of cells that you designate to print when you don't want to print the entire worksheet. When you print a worksheet after defining a print area, only the print area is printed. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet.
Excel saves your print area with your workbook file. If you receive an Excel file from a colleague and can't print an entire worksheet from it, check for a saved print area and remove it.
A worksheet can have multiple print areas. Each print area will print as a separate page. Note: The print area that you set is saved when you save the workbook. To see all the print areas to make sure they’re the ones you want, click View Page Break Preview in the Workbook Views group. When you save your workbook, the print area is saved too.
Add cells to an existing print area You can enlarge the print area by adding adjacent cells. If you add cells that aren’t adjacent to the print area, Excel creates a new print area for those cells.
On the worksheet, select the cells that you want to add to the existing print area.
MrExcel.com debuted on November 21, 1998. MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided 'as is' and we do not guarantee that they can be used in all situations. This site contains affiliate links.
Any affiliate commissions that we earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com running. You can earn a commission for sales leads that you send to us by joining our. Excel ® is a registered trademark of the Microsoft Corporation.
MrExcel ® is a registered trademark of Tickling Keys, Inc. All contents © 1998 - 2019 MrExcel Publishing All rights reserved.