Insert the date in a footer

To add the current date at the time of printing to the bottom of every printed page, simply insert the date in the worksheet footer. Similarly, you can also add the date to the top of every printed page.

  1. Click Insert > Header & Footer

    Header & Footer option on the Insert tab
  2. Scroll down to the bottom of the worksheet.

  3. Click on the left, center, or right footer box at the bottom of the worksheet.

    Add Footer
  4. Click Design > Current Date.

    Headers & Footers Design Ribbon tab
  5. To exit the footer view, click anywhere in the worksheet, and then click View > Normal.

Where is the footer in my workbook?

Click View > Page Layout. Footers show up only in Page Layout view, Print Preview, and on printed pages.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.