Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add a custom header for all pages in workbook?
How do I add a custom header for all pages in workbook without having to
manually enter it for every page? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add a custom header for all pages in workbook?
One way:
Group all the worksheets (select the left-most, then shift-click the tab of the right-most). Just remember to ungroup (right-click any worksheet tab and choose Ungroup sheets) before making any changes that you DON'T want to apply to all. In article , 10sfan wrote: How do I add a custom header for all pages in workbook without having to manually enter it for every page? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add a custom header for all pages in workbook?
Group the worksheets first then apply the header.
To group: click the tab of the first worksheet; hold SHIFT; click the tab of the last worksheet The same trick works to print all print areas. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "10sfan" wrote in message ... How do I add a custom header for all pages in workbook without having to manually enter it for every page? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add a custom header for all pages in workbook?
Right-click on first sheet and "select all sheets"
Make your custom header on the active sheet and will be done to all sheets. DO NOT FORGET to right-click and "ungroup" when done. Gord Dibben MS Excel MVP On Mon, 26 Feb 2007 08:25:18 -0800, 10sfan wrote: How do I add a custom header for all pages in workbook without having to manually enter it for every page? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add a custom header for all pages in workbook?
"JE McGimpsey" wrote: One way: Group all the worksheets (select the left-most, then shift-click the tab of the right-most). Just remember to ungroup (right-click any worksheet tab and choose Ungroup sheets) before making any changes that you DON'T want to apply to all. In article , 10sfan wrote: How do I add a custom header for all pages in workbook without having to manually enter it for every page? Thank you so much! This will save me so much time. I seached the documentation endlessly to no avail. I appreciate your taking time to answer - as well as the others who also answered. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I repeat same custom header for entire workbook | Excel Discussion (Misc queries) | |||
Can you link a custom property to an Excel custom header text? | Setting up and Configuration of Excel | |||
How to save a custom header/footer on ea. sheet of a workbook? | Excel Worksheet Functions | |||
Share Excel worksheet custom header/footer throughout workbook. | Excel Worksheet Functions | |||
how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) |