Header copy across workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Slight variation on a common question:

Can I copy the header/footer information from a worksheet in one open
workbook to a worksheet in a different open workbook?

Thanks!
BruceD
 
Open up the file|page setup, show the header/footer section that you want to
copy. Copy it by selecting all of it and hitting ctrl-c.

Close that dialog.

Open up the other worksheet's file|page setup, show that header/footer section
and paste using ctrl-v.

You may end up doing it 6 times????
 
Thanks, Dave, that works!
But you're right - I'll have to do it 6 times. I wish there were a more
streamlined way.

BruceD
 
Back
Top