Header Footer on multiple worksheets

[terry]

Is there anyway to have the same header/footer print across an entire
workbook (ie multiple worksheets) without using the custom header footer on
each worksheet within the file? Thanks

 

[Pete_UK]

This reply from Gord Dibben was posted a few days ago in response to a
similar enquiry:


Select the sheet with the custom header and footer.
Right-click on the sheet tab and "select all sheets".
Go into File>Page Setup>Headers and Footers.
Click on OK without doing anything else.
All sheets now have that header/footer.
Right-click and "ungroup sheets" or select any sheet but the active
sheet.

Gord Dibben MS Excel MVP


This assumes there is a custom header and footer already defined for
one sheet.

Hope this helps.

Pete