Insert date and time in a header or footer

  1. On the View menu, click Header and Footer.
  2. Click Custom Header or Custom Footer.
  3. Click in the Left section, Center section, or Right section box.
  4. On the row of buttons in the Header or Footer dialog box, click Date Button image or Time Button image.
  5. If you want, do one or more of the following:
    • To start a new line, press ENTER.
    • To delete a date or time from a header or footer, select &[Date] or &[Time] and then press DELETE.

 Note    Make sure the header or footer margin allows enough space for the custom header or footer.

Applies to:
Excel 2003