How to fast enter/update date/time in Excel

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).