Exceljet

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.

Course 

Related shortcuts

CtrlShift:
;
Ctrl;
;
Author 
Dave Bruns

Download 200+ Excel Shortcuts

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