Copying page set ups from one worsheet to another.

[John B-B]

Can anybody advise how to copy headers and footers from
one worsheet to others in the same workbook?

 

[Frank Kabel]

Hi
one way:
- make sure the worksheet with the settings is the first sheet in your
workbook
- select this sheet and hold down the SHIFT key while selecting the
other sheet(s)
- goto 'File - Pagesetup'
- hit OK

Note: This will copy ALL settings in this dialog (not only
headers/footers)