To insert the current time, press Ctrl+Shift+ (semi-colon). Do one of the following: To insert the current date, press Ctrl+ (semi-colon). You see when I put some value in a cell of column A, the adjacent column B cell shows the date and time I am changing the cell. On a worksheet, select the cell into which you want to insert the current date or time.