Excel Forum



Excel Magic Trick #188: Page Setup Across Multiple Sheets


Page Set Up Across Multiple Sheets Or To Another Workbook. Headers and Footers.
Highlight all the sheets you want to add Page Setup to and then add the Page Setup
To highlight multiple sheets, click on the first sheet, hold shift, click on the last sheet
If you copy a sheet to another workbook, the Page Setup will also be moved.
To copy a sheet to another workbook, right-click the sheet, point to "Move or Copy", Select "To book", "Select before sheet", check the "Create a copy" checkbook





Got a Question? Ask it Here in the Forum.