Quick, clean, and to the point

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.


Related shortcuts

Dave Bruns

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.