Header Footer on multiple worksheets


T

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
 
Ad

Advertisements

P

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
 

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

Top