Excel Magic Trick #188: Page Setup Across Multiple Sheets

Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT185-202.xls
Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT185-202Finished.xls
Full Page With All File Links: http://people.highline.edu/mgirvin/excelisfun.htm

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

Видео Excel Magic Trick #188: Page Setup Across Multiple Sheets канала ExcelIsFun