Right click on a tab of the spreadsheet, select all sheets, then enter page
setup and your header/footer.

Ewan

"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