Practice worksheet included with online video training.
Shortcuts for the current Date and Time in Excel
In this lesson, we'll look at two useful shortcuts for entering the current date and time. Control-semicolon will enter the current date; control-shift-semicolon will enter the current time.
Let's take a look.
To enter the current date in Excel, use the shortcut control-semicolon.
To enter the current time, use the shortcut control-shift-semicolon.
If you want to enter both the current date and the current time, type control-semicolon, a space, then type control-shift-semicolon.
Course
Related shortcuts
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.