Can I duplicate headers and footers on multiple sheets?
 

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.

Can I duplicate headers and footers on multiple sheets?
 

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

--
Regards,

Peo Sjoblom


"HeatherDBecerra" wrote in
message ...
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.

Can I duplicate headers and footers on multiple sheets?
 

Thank you sooooo much!! It worked!!

"Peo Sjoblom" wrote:

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

--
Regards,

Peo Sjoblom


"HeatherDBecerra" wrote in
message ...
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.