Description: This article describes how insert page numbers 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 Page Number button.

6. This will insert the code to show page numbers on each sheet.

7. When out of the Header and Footer View, the actual page number will be displayed.

8. The total number of pages can also be displayed by clicking the Number of Pages button.

9. As seen below, the proper code will be inserted and when out of the Header and Footer View, the actual total number of pages that exist will be displayed.