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?