To insert the current time, press Ctrl+Shift+ (semi-colon). To insert the current date, press Ctrl+ (semi-colon). On a worksheet, select the cell into which you want to insert the current date or time. Because that cell’s value doesn’t change, it’s considered static. 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. Insert a static date or time into an Excel cellĪ static value in a worksheet is one that doesn’t change when the worksheet is recalculated or opened.
