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.
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.
Quick, clean, and to the point.