How do I add a custom header for all pages in workbook without having to
manually enter it for every page?

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?

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

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?

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?