This lesson is part of Core Excel
Purchase the course to access all 18 sections and start learning.
Already purchased? Log in
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.