Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I repeat same custom header for entire workbook
I am trying to repeat the same custom header in every worksheet of my
workbook which is scanned in logo but at the moment I have to set it up for every worksheet- Is there anyway it can be repeated automatically on every worksheet in ther book |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I repeat same custom header for entire workbook
Try grouping the worksheets first.
Click on the first tab and ctrl-click on subsequent tabs (or right click on any and choose Select all sheets). Then do the page setup. Lots of these settings will be applied to all the sheets that are grouped. Be careful. Make sure you ungroup the sheets when you're done. Almost all the changes you make to a grouped sheet will affect the other sheets in that group. JillyB wrote: I am trying to repeat the same custom header in every worksheet of my workbook which is scanned in logo but at the moment I have to set it up for every worksheet- Is there anyway it can be repeated automatically on every worksheet in ther book -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One workbook to another . . . | Excel Discussion (Misc queries) | |||
How can I using Excel custom document properties in the header? | Excel Worksheet Functions | |||
custom header | Excel Discussion (Misc queries) | |||
Custom List Header | Excel Discussion (Misc queries) | |||
One header for all worksheets in workbook | Excel Discussion (Misc queries) |