Excel Shortcuts to Insert Current Date and Time [3 Examples]

Inserting the current date and time is generally required as you are working with Excel worksheets. The following shortcuts can be used for inserting date and time in Excel:

How to insert the current date and time in Excel by shortcut

Inserting the current date and time in cells is generally required as you are working with Excel worksheets. The following shortcuts can be used for inserting date and time in Excel:

Insert date shortcut

In Windows OS, you may use the following shortcut for entering the date:

Ctrl + ;

For Mac OS:

^ + ;

This shortcut will insert only the current date in the Excel cell.

Video Demo of inserting date in Excel on Windows

Step by Step

Step 1:

Click on the cell where you want to insert the current date

Step 2:

Press Ctrl + ;

Inserting current system time in Excel shortcut

For inserting time in the selected cell, use this shortcut:

Ctrl + Shift + ;

So, basically it iss

Ctrl + :

Video demo of  inserting current time in Excel on Windows

Steps for entering current time on Windows

Step 1:

Click on the cell where you want to insert the current time

Step 2:

Press Ctrl + :

i.e. Ctrl + Shift + ;

Inserting date and time by shortcut

Basically, this is the combination of the above two shortcuts to insert the current date and time without picking the hand to the mouse.

Steps for inserting date and time

Step 1:

Click/Select the cell where you want to insert the current date and time

Step 2:

Press Ctrl +;

Step 3:

Press spacebar

Step 4

Press Ctrl + shift + ;

Video Demo