Set Print Area Excel Multiple Sheets. In the page setup group click. Repeat steps 1 and 2 for other print areas.
With the help of the paste special feature you can link the copied ranges to the original data in this way. Each print area gets a. To set more than one print area hold down the ctrl key and select the areas you want to print.
Kutools for excel s print multiple selections wizard can help excel users to print multiple selections from different sheets together without page breaks on one page.
Kutools for excel includes more than 300 handy tools for excel. How to create a print area on multiple sheets 1. Open your workbook and select the first sheet. Select a range you want to set as print area in one of worksheets and press alt f11 keys to open the microsoft.
