Can I duplicate headers and footers on multiple sheets?

G

Guest

I have a worksheet that has a custom header and footer and I want the exact
same header and footer on sheet 2 and I can not find a way to copy the info
to other sheets without copying and pasting each section separatly.
 
P

Peo Sjoblom

Just group the sheets before you apply the header/footer;
click first sheet, hold down shift and click last sheet, apply the
header/footer
ungroup the sheets
 
G

Guest

Thank you sooooo much!! It worked!!

Peo Sjoblom said:
Just group the sheets before you apply the header/footer;
click first sheet, hold down shift and click last sheet, apply the
header/footer
ungroup the sheets
Click to expand...
 

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

Pictures in Headers and Footers 1
tab names are wrong when printing custom footers (using [&tab] ) 1
How do I set the default font for headers and footers in Excel? 1
headers in worksheet 4
How to change the footer only, on multiple worksheets in Excel? 1
In Excel, can I copy Headers and Footers between Worksheets? 1
Copy headers and footers to other pages? 1
transferring headers and footers 1

Top