Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Sharon
 
Posts: n/a
Default add a header and or footer to all sheets/tabs

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.
  #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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Give multiple charts on a worksheet/workbook same header or footer Ches Excel Discussion (Misc queries) 8 July 4th 05 09:29 PM
Give multiple charts on a worksheet/workbook same header or footer Ches Charts and Charting in Excel 2 July 4th 05 04:58 PM
How do I hide the header and footer on page 1 in Excel? Performance Technology Excel Discussion (Misc queries) 1 April 14th 05 09:36 PM
Custom Header and Footer Dave Excel Discussion (Misc queries) 1 March 23rd 05 08:24 PM
How to insert a picture in the Footer (not the Header) in Excel 20 jmon Excel Worksheet Functions 2 March 17th 05 05:59 AM


All times are GMT +1. The time now is 12:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"