View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Victoria Victoria is offline
external usenet poster
 
Posts: 35
Default 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?