Copying page set ups from one worsheet to another.

  • Thread starter Thread starter John B-B
  • Start date Start date
J

John B-B

Can anybody advise how to copy headers and footers from
one worsheet to others in the same workbook?
 
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)
 
Back
Top