How to copy headers/footers between worksheets
 

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

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"




--
Regards Ron de Bruin
http://www.rondebruin.nl



"BruceD" wrote in message ...
Can I copy headers/footers between worksheets in a workbook without copying
the entire sheet?

How to copy headers/footers between worksheets
 

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.

"Ron de Bruin" wrote:

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"




--
Regards Ron de Bruin
http://www.rondebruin.nl



"BruceD" wrote in message ...
Can I copy headers/footers between worksheets in a workbook without copying
the entire sheet?