Header and Footer

P

PAL

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.
 
G

Gord Dibben

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
 
Top