This example teaches you how to add information to the header (top of each printed page) or footer (bottom of each printed page) in Excel.
1. On the View tab, in the Workbook Views group, click Page Layout, to switch to Page Layout view.
2. Click Add header.
3. On the Header & Footer tab, in the Header & Footer Elements group, click Current Date to add the current date (or add the current time, file name, sheet name, etc).
Result:
Note: Excel uses codes in order to automatically update the header or footer as you change the workbook.
4. You can also add information to the left and right part of the header. For example, click the left part to add the name of your company.
5. Click somewhere else on the sheet to see the header.
6. On the Header & Footer tab, in the Options group, you can add a different first page header/footer and a different header/footer for odd and even pages.
7. On the View tab, in the Workbook Views group, click Normal, to switch back to Normal view.
How do I add an element to the center section of the header?
Add built-in header and footer elements for a worksheet
- Click the worksheet to which you want to add specific header or footer elements.
- On the Insert tab, in the Text group, click Header & Footer.
- Click the left, center, or right header or footer text box at the top or the bottom of the worksheet page.
How do you add an element to the center section of the header to display the current date on Excel?
Double-click on the header section where you want to insert the current date (here, the center section). You’re automatically taken to the Header & Footer tab in the Ribbon. Here, choose the Current Date. As a result of the previous step, in the center section of the header, you can see &[Date].
How do I insert the current date in Excel header?
Insert the date in a footer in Excel
- Click Insert > Header & Footer.
- Scroll down to the bottom of the worksheet.
- Click on the left, center, or right footer box at the bottom of the worksheet.
- Click Design > Current Date.
- To exit the footer view, click anywhere in the worksheet, and then click View > Normal.
How do you insert a header with the current date in the center header text box and then make the worksheet active?
Headers and Footers
- On the View tab, in the Workbook Views group, click Page Layout, to switch to Page Layout view.
- Click Add header.
- On the Design tab, in the Header & Footer Elements group, click Current Date to add the current date (or add the current time, file name, sheet name, etc).