Set Print Area Excel Multiple Sheets. While holding down the ctrl key click on each of the other individual sheets you want to print. Kutools for excel includes more than 300 handy tools for excel.
Click ctrl p and then select print. 1 select the range of cells that you want to set as the print area in your worksheet. Repeat steps 1 and 2 for other print areas.
On a new sheet right click any blank cell and choose paste special linked picture.
Open your workbook and select the first sheet. Highlight or select the range of cells you want to print. But that would make viewing the spreadsheet on the screen that much more difficult as you would have to click between the two in order to analyze the data. 1 select the range of cells that you want to set as the print area in your worksheet.
