View Single Post
  #3   Report Post  
Nick Hodge
 
Posts: n/a
Default

Yoda

Sure

Group the sheets by

1) Clicking on one and holding the shift key down and selecting another
(Selects contiguous tabs)

2) Hold the Ctrl key down while clicking on sheet tabs you want to 'group'
(Selects non-contiguous sheets)

While you have sheets grouped, anything you do on one is also done on the
others, including FilePage setup...Headers & Footers!

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Master Yoda" <Master
wrote in message
...
I want to use same header for multiple sheets in Excel, and only change a
few
items in the header, or footer; i.e. summary of billing for separate
projects using the same content headers for the body of the sheet, but the
header changes to note a specific project. I can Copy & Paste the sheet
content and then modify from sheet to sheet; but I did not find a ay to
copy
the Header & Footer from sheet to sheet without having to re-enter all the
Header/Footer info again. Can it be done??