Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Give multiple charts on a worksheet/workbook same header or footer | Excel Discussion (Misc queries) | |||
Give multiple charts on a worksheet/workbook same header or footer | Charts and Charting in Excel | |||
How do I hide the header and footer on page 1 in Excel? | Excel Discussion (Misc queries) | |||
Custom Header and Footer | Excel Discussion (Misc queries) | |||
How to insert a picture in the Footer (not the Header) in Excel 20 | Excel Worksheet Functions |