Set Print Area Excel 2016. Click print area on the page layout tab. Select the set print area option shown in the snapshot directly below.
To select multiple. More informative way to define print area in excel. Save close and reopen the excel file.
On the page layout tab in the page setup group click print area.
To select multiple. If the cells that you want to. Set one or more excel print areas open a worksheet and select the cells that you want to be part of the print area. Click set print area.