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.