Method 2 – Changing the Print Area in Excel by Adding Cells Define the print area:B4:E14and see thePrint Preview. To add cells fromB15toE19to that print area: Select your Print Area —> Page Layout Tab —> Print Area —> Add to Print Area PressCTRL + Pto see thePrint Preview:B4:...
You will see blue lines indicating the page breaks. The range within the boundary is the print area. To adjust the print area, hover your mouse cursor over the page break line until it turns into a two-sided arrow. Click and drag the page break line to include or exclude cells in the...
In this tutorial, you will learn how to select print area in Excel manually and how to set print ranges for multiple sheets by using macros. When you hit thePrintbutton in Excel, the entire spreadsheet is printed by default, which often takes multiple pages. But what if you don't really...
How to set the print area in Excel Most times, we only want to print a part of our Excel worksheet, not its entirety. To do that, we need to first define or set a print area A print area is one or more ranges of cells in your sheet that you designate to print when you don...
How to Set a Print Area in Excel You can set one or more print areas in the same Excel sheet. To set a single print area,select the cells. Then, go to the Page Layout tab and click the Print Area drop-down arrow in the ribbon. Choose "Set Print Area." ...
Once you have selected your page break, click on theFiletab, selectPrint, and preview how your spreadsheet will look when printed. As you can see, the preview will show thepage breakin between rows 18 and 19. Additional Tips Clearing Print Area: If you want to remove the set print area...
Method 1 – Using Keyboard Shortcuts to Center the Print Area in Excel Step 1: Select the entire data range and press Ctrl and P. In the new window, click Page Setup. In Page Setup, click Margins. Click Horizontally and Vertically in Center on Page. Click OK. Step 2: The Print Previ...
Steps to Set the Print Area in Excel First, select the single or multiple cell range using the “Control” key to set a print area in the sheet. Afterward, go to the “Page Layout” tab and click the “Print Area” icon. In the print dropdown, click on the “Set Print Area”. ...
To extend an existing print area, select the cells you want to add, and in the Ribbon, go to Page Layout > Print Area > Add to Print Area.If you are adding adjacent cells, you will just enlarge the existing print area; but if you are adding non-adjacent cells, you will create a ...
A print area specified using the above steps is specific to that worksheet only. Hence, you can set different print areas in different worksheets. When you save the workbook, Excel saves the print area as well. The next time you open the workbook, the print area would still be there. Whe...