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.