Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Can someone tell me how to copy a header/footer from 1 workbook sheet to each
additional workbook sheet? |
#2
![]() |
|||
|
|||
![]()
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 "BMan" wrote in message ... Can someone tell me how to copy a header/footer from 1 workbook sheet to each additional workbook sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
numbering all pages in worksheet | Excel Discussion (Misc queries) | |||
how to search multiple pages for data | Excel Worksheet Functions | |||
Single worksheet, multiple pages? | Excel Discussion (Misc queries) | |||
How do I delete pages? | Excel Discussion (Misc queries) | |||
combining multiple pages from Web automatically | Excel Discussion (Misc queries) |