Excel Forum
Similar Content
Scale Data for Printing in Excel - Fit more onto a Printed Page
Tutorial: This tip shows you how to fit more Excel data onto a page for printing. This does not chan...
How to use Vlookup Across Multiple Worksheets in Excel
Tutorial: This tutorial shows you how to use the Vlookup function across multiple worksheets within ...
Vlookup Across Multiple Workbooks
Tutorial: How to use the VLOOKUP function across multiple workbooks in Excel. This will create a lin...

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.