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