ExcelBanter - Headers on multiple pages

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Headers on multiple pages (https://www.excelbanter.com/excel-worksheet-functions/13042-headers-multiple-pages.html)

BMan

Headers on multiple pages

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

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

"BMan" wrote in message
...
Can someone tell me how to copy a header/footer from 1 workbook sheet to
each
additional workbook sheet?

All times are GMT +1. The time now is 12:08 AM.