Melanie

Existing workbooks..........Right-click the first worksheet tab. Choose
"slect all sheets"

Set up your header for the active sheet and all others will get that header.

For new workbooks see Frank's answer new workbook template.

Gord Dibben Excel MVP


On Tue, 14 Dec 2004 12:15:01 -0800, "Melanie"
wrote:

I have several worksheets within one workbook. I want to be able to set-up a
default header that I can use on each worksheet without having to type the
same information on each Page Set-up under the header information. Is thier
a way to set a default header for the whole workbook or at the very least to
put a "default header" in the drop down box to choose the header I want on
each workbook?