For instance, the print area for our dataset is from Cell B4 to Cell C9 (see in the picture below).
![how to change print area in excel how to change print area in excel](https://exceltable.com/en/printing-sheets/images/printing-sheets1-3.png)
![how to change print area in excel how to change print area in excel](https://trumpexcel.com/wp-content/uploads/2015/12/Set-the-Print-Area-in-Excel-Worksheets-Set.png)
Or you can press Ctrl + F3 as the keyboard shortcut to open the Name Manager dialogue box. Go to the tab Formulas -> Defined Names -> Name Manager.Whenever you set a print area, a named range – Print_Area – is defined in Excel. Change Print Area by Using Name Manager in Excel If the newly added cells are non-adjacent then those new data will be printed on a different page.ģ.If the newly added cells are adjacent to the existing print area then they will be printed on the same page.You must have at least one print area in the worksheet for Add to Print Area option to appear.Now, remember some very important key points when you execute this process: This will expand the print area by adding those new data into the Excel sheet while printing. Go to Page Layout -> Print Area -> Add to Print Area.Select the new cells/ rows/ columns that you want to add.If you want to add more cells or rows or columns with the existing print area, then follow the steps below. By Adding New Cell/ Rows/ Columns to Expand the Print Area You can check that in the Print Preview option while printing.Ģ. It will change the previous print area settings and print only the newly selected area. Go to Page Layout -> Print Area -> Set Print Area.Just select the specific part that you want to print from the spreadsheet.
![how to change print area in excel how to change print area in excel](https://cdn.educba.com/academy/wp-content/uploads/2019/01/Print-Area-in-Excel.png)
You can manually change this pre-defined print area of Excel.