How do I add a custom header for all pages in workbook?

[Guest]

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

 

[JE McGimpsey]

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.

 

[Bernard Liengme]

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

 

[Gord Dibben]

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

 

[Guest]

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.

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.