Description: This article describes how to insert the current date and time in an Excel 2010 header or footer.

1. To insert the current date and time into an Excel 2010 header or footer, click the Insert tab.

2. Click the Header & Footer button.

3. The initial input position will be in the header. Clicking the Go to Footer button will move the insert position to the footer.

4. Clicking the Go to Header button will move the insert position back into the header.

5. Once in the desired header or footer location, press the Current Date button to insert the current date.

6. This will insert the code to show the current date on each sheet.

7. When out of the Header and Footer View, the actual current date will be displayed.

8. The current time can also be displayed by clicking the Current Time button.

9. As seen below, the proper code will be inserted and when out of the Header and Footer View the actual current time will be displayed.