Set Print Area Excel Multiple Sheets. In the page setup group click. In the page setup area you ll see an option for print.
On the page layout tab in the page setup group click print area and then click set print area. 1 select the range of cells that you want to set as the print area in your worksheet. To set more than one print area hold down the ctrl key and select the areas you want to print.
To set more than one print area hold down the ctrl key and select the areas you want to print.
Highlight or select the range of cells you want to print. In the page setup area you ll see an option for print. With the help of the paste special feature you can link the copied ranges to the original data in this way. On a new sheet right click any blank cell and choose paste special linked picture.
