Header copy across workbooks
 

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

Header copy across workbooks
 

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????

BruceD wrote:

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

--

Dave Peterson

Header copy across workbooks
 

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

"Dave Peterson" wrote:

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????

BruceD wrote:

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

--

Dave Peterson