Bruce

Select the sheet with the header/footer you wnat.

Right-click and "Select all sheets".

FilePage SetupHeaders/Footers and OK your way out.

All sheets will have that setup.

DO NOT FORGET to ungroup the sheets after you're done. What is being done to
one will be done to all.

Could make for some interesting changes<g


Gord Dibben Excel MVP

On Tue, 11 Jan 2005 13:19:05 -0800, BruceD
wrote:

Can I copy headers and footers from one worksheet to another in a workbook
without copying the entire sheet?