Insert the date in a footer in Excel

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.

You cannot insert a footer in Excel for the web.

Note: If you inserted a footer in your spreadsheet using Excel desktop, and then opened the spreadsheet in Excel for the web, the footer will not be visible.

If you have the Excel desktop application, you can use the Open in Excel button to open the workbook and insert the date in a footer.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

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.