Darren,

Try selecting all of the relevant sheets selected when you apply your
header/footer.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"Darren M" wrote:

Is it possible to set the header and footer in an Excel file so it is
repeated across the worksheets contained within the file. i.e. Each workbook
contains 3 worksheets. I set the header and footer info on worksheet 1.
However I have info on Worksheets 2 and 3 and the header and footer info
doesn't copy across. I have to manually enter them. Can you help. Is there an
easy way to do this?


Regards

Darren M