Shortcut to Enter Current Date and Time in Excel
Overview
Introduces keyboard shortcuts that insert the current date and time directly into a cell in Excel. Particularly useful when you need to manually record logs.
Guide
- ctrl;: Inserts the current date into the selected cell.
- ctrl:: Inserts the current time into the selected cell.
Note that ctrl: is equivalent to ctrlshift;.
Notepad tip
As a side note, in Notepad, pressing the F5 key inserts the current date and time.