Abstract
In this video, we show useful shortcuts for entering the current date and time.
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.
