Headers on multiple pages

G

Guest

Can someone tell me how to copy a header/footer from 1 workbook sheet to each
additional workbook sheet?
 
B

Bob Umlas

Select all the sheets to contain the same page setups (ctrl/click the sheet
tab or shift/click the sheet tabs or right-click the sheet tab and use
Select All Sheets) -- then activate the sheet with the "correct" setup, and
simply use File/Page Setup & click OK. Get out of group edit mode
(shift-click a sheet tab) and you're done.
Bob Umlas
Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Header/Footer on entire workbook 4
Excel Move or Copy Stopped Working? 0
Excel shortcut options 0
printing page # on sheets 1
Excel Unique last page footer 1
iserror, index & if 4
Help for sharing a worksheet from a excel sheet 1
Damse in Distress Need Help!!! 3

Top