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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Header/Footer Date Format 2
No headers & footers in the worksheets 1
Excel-Footer Mass change of only Header and not footer 1
How do I make a single header/footer common across all worksheets? 1
Can I duplicate headers and footers on multiple sheets? 2
How to change the footer only, on multiple worksheets in Excel? 1
HEADER & FOOTER 1
how to apply the same header or footer to all sheets in workbook 1

Top