Headers in Excell

A

Aurora

I am using Excell 2000

I have several charts on different sheets in one workbook.
I would like the same header to be on all of the sheets.
Is there a way to do this without individually having to
type them all in?

Also in the header is a Month/year date. I would also
like to be able to change the header once and have all of
the headers corrected. Is this possible?

Aurora
 
D

DDM

Aurora, first group the worksheets, then create your header. The header will
be the same for all grouped sheets. To modify the header for all grouped
worksheets, first group the worksheets, then modify the header.

To group worksheets, you can select one worksheet tab, then holding down
Ctrl, you can click to select others. Or you can right-click one worksheet
tab and select Select all sheets. After you create (or modify) your header,
right-click any sheet tab and select Ungroup sheets.
 
Top