Repeat Page Set-Up

[Jeannie]

How do you repeat page setup for different worksheets
within a workbook? I want the same headers/footers/page
numbering, etc. on each worksheet. Thanks.

 

[Bob Umlas]

With the sheet with the desired settings active, ctrl/click the other sheet
tabs (or select All sheets), then use File/Page Setup and just click OK.
Then shift/click another sheet tab to get out of group mode, and you're all
set!

Bob Umlas
Excel MVP