How to Add Current Date to Center Section of Excel Header?

Are you wondering how to display the current date in the center section of the Excel header?

Do you want to know the steps to add the current date to the center section of the header in Excel?

Yes, you can easily add the current date to the center section of the header in Excel!

There are two ways to achieve this. You can either use the Insert Date button or type a formula directly.

If you choose to use the Insert Date button, follow these steps:

  • Open the Excel worksheet.
  • Click on the Insert tab.
  • In the Header & Footer group, click on the Header button.
  • Click on the Center section of the header.
  • Click on the Insert Date button.
  • Select the date format you want to use.
  • Click OK to close the Date Format dialog box.
  • Click anywhere in the worksheet to exit the header and footer editing mode.

If you prefer to use a formula, here's how you can do it:

  • Open the Excel worksheet.
  • Click on the Insert tab.
  • In the Header & Footer group, click on the Header button.
  • Click on the Center section of the header.
  • Type the following formula into the header cell: =TEXT(TODAY(),"MM/DD/YYYY")
  • Press Enter to accept the formula.
  • Click anywhere in the worksheet to exit the header and footer editing mode.

By following these simple steps, you can quickly add the current date to the center section of the Excel header, making your worksheet more dynamic and informative!

← How to unhide pictures on iphone and ipad Azure machine learning for predictive analytics solutions →

More Posts: