To begin automating headers and footers in Excel using VBA, you’ll first need to access the Developer tab. This tab provides the tools necessary to write and run VBA code.

In Excel’s custom headers and footers box, the ampersand character (&) is used as a marker to indicate that a special formatting code follows. For example, inserting the characters & [Date]& [Time] ...

When you want to add page numbers to a document header or footer, you can use menu commands. However, if all you need is to do is quickly add a page number to the bottom of your pages, you may ...

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.