View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Group the sheets first. Right-click any sheet tab, and hit Select all
sheets. Don't forget to ungroup when you're done!!
************
Anne Troy
www.OfficeArticles.com

"Sharon" wrote in message
...
I have a large workbook that I need to add a header and footer to each
sheet/tab. I do not want to have to go to each sheet and do this, there
are
grapghics and propreitary notes, etc. it would be a lot of work to have to
go
to each sheet.

Can I add the header and footeronce and have it apply to all sheets/tabs
in
the workbook? Please advise ASAP. Thanks for any help you can provide.