How to copy headers/footers between worksheets

B

BruceD

Can I copy headers/footers between worksheets in a workbook without copying
the entire sheet?
 
R

Ron de Bruin

Hi Bruce

Select all your sheets first (right click in a a sheet tab "select all sheets"
Add your header and footer
Ungroup the sheets(right click in a a sheet tab "ungroup sheets"
 
V

Victoria

Thank you so much!!! I had over 60 worksheets that I needed to add the same
footer to and everyone was telling me it can't happen and that I'll need to
do it on each individual one.

Thank you so much for this quick and easy fix.
 
Top