Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
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 |