Insert a static date or time in Excel

A static value in a worksheet is one that doesn’t change when the worksheet is recalculated or opened. When you press a key combination such as CTRL+; to insert the current date in a cell, Excel “takes a snapshot” of the current date and then inserts the date in the cell. That cell’s value doesn’t change, so it’s considered static.

  1. On a worksheet, select the cell into which you want to insert the current date or time.
  2. Do one of the following:
    • To insert the current date, press CTRL+; (semi-colon).
    • To insert the current time, press CTRL+SHIFT+; (semi-colon).
    • To insert the current date and time, press CTRL+; (semi-colon), then press SPACE, and then press CTRL+SHIFT+; (semi-colon).