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.

Launch Microsoft Excel 2010 and open the spreadsheet you want to edit. Select the worksheet for which you want to insert the page number. Click the "View" tab on the upper side of the Excel window.

Open a worksheet and, on the toolbar, click on File, Page Setup and then the Header/Footer tab. Excel provides a bunch of default headers and footers. To see them, click on the down arrow at the right ...