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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
JE McGimpsey said:
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.
Click to expand...

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.
 
Back
Top