Excel can apply a header or footer that you designate to every new worksheet that you insert.

1. Create a new workbook with one worksheet, and set up the header and footer you want on that worksheet.
2. On the File menu, click Save As.
3. In the File name box, type Sheet.
4. In the Save as type box, click Template (*.xlt).
5. In the Save in box, select the XLStart folder.
   For information about where to find this folder, type location of settings in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search.

The header and footer in XLStart\Sheet.xlt become the default header and footer for new worksheets. If you want a different header or footer on a particular worksheet, just change the header or footer on that worksheet.