Transcript
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.
In the latest version of Mac Excel, the shortcut for current time is Command + semicolon.
