I create a worksheet with only the custom header in it and any other
information which may be the same from sheet to sheet and give it a name,
i.e. "format". I then copy that sheet as many times as I need to in the same
workbook and change the name of each worksheet to somethink more descriptive,
i.e. "TAB 1". This is probably the long way to do it, but it works for me.

Heather

"Diane" wrote:

> I have a custom header in one Excel worksheet that I need to copy into
> several other worksheets. Is there a way to do this without reentering the
> information separately for each sheet?