Can I duplicate headers and footers on multiple sheets?

H

HeatherDBecerra

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
 
H

HeatherDBecerra

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