I have a header and footer on one worksheet. Is there a way to copy it to
other worksheets without starting from scratch. I have about 10 worksheets.
Thanks.

Hi,

1. Select the sheet with the custom header and footer
2. Hold down the Ctrl key and click the tabs for all the other sheets you
want to get this header and footer
3. Choose File, Page Setup, Header & Footer, Footer, OK, OK.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"PAL" wrote:

I have a header and footer on one worksheet. Is there a way to copy it to
other worksheets without starting from scratch. I have about 10 worksheets.
Thanks.

Just a caveat with this method.

ALL your custom print setups for each sheet will take on the attributes of
the first selected sheet.

ALL except print range and rows to repeat at top, that is.


Gord Dibben MS Excel MVP

On Tue, 6 Jan 2009 15:00:00 -0800, Shane Devenshire
wrote:

Hi,

1. Select the sheet with the custom header and footer
2. Hold down the Ctrl key and click the tabs for all the other sheets you
want to get this header and footer
3. Choose File, Page Setup, Header & Footer, Footer, OK, OK.