Ctrl+Shift+Colon: Enters Current Time

The shortcut Ctrl+Shift+Colon (:) is to enter the current time. To enter today's date, please refer to the shortcut "Ctrl+Semicolon".

Step 1: Click any cell you want to enter the time;

Step 2: Press and hold the Ctrl and Shift keys, and press the colon (:) sign from the keyboard. You will see the current time.

Check More Excel Shortcuts

Leave a Reply