How to Add a Footer to All Sheets in Excel. Adding a footer to all of your sheets in an Excel workbook is a good way to ensure continuity between each sheet, especially if you are printing them out.

You can insert or add Header and Footer in Excel spreadsheet using this tutorial. Insert page number, current date and time, etc.

In Excel 2003, choose Header and Footer from the View menu. Page Layout is new to 2007. Now you’re ready to add the header data: Click the Click To Add Header prompt and enter your header text.

Another way is to go to the toolbar and click on File, Page Setup , the Header/Footer tab and then the Custom Header box. Then fill in the path and filename and click OK. Yet another way was submitted ...