Set Print Area Excel 2016. Create the print area in excel. Select the set print area option shown in the snapshot directly below.
To set more than one print area hold down the ctrl key and select the areas you want to print. Each print area gets a. Select a range of cells.
Select a range of cells.
Each print area gets a. Each print area gets a. On the page layout tab in the page setup group click on the print area dropdown list. Select a range of cells.