Excel: Shortcut for Entering the Current Date and Time

ID: Q89776

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0, 7.0, 97
Microsoft Excel for the Macintosh, versions 2.x, 3.0, 4.0, 5.0
Microsoft Excel for OS/2 versions 2.2, 2.21, 3.0

In Microsoft Excel, you can quickly enter the current date and time using the following keystrokes:

For the current date, press:


   CTRL+;   (COMMAND+HYPHEN on the Macintosh)

For the current time, press:


   SHIFT+CTRL+:  (COMMAND+; on the Macintosh)

These keystrokes enter the date and time in the formula bar. To complete the entry in the cell, press ENTER (RETURN on the Macintosh) after you have entered the date or time in the formula bar.

To enter both the date and the time in a single cell:

Press CTRL+; (COMMAND+HYPHEN on the Macintosh).

Press SPACEBAR to put a space between the date and time.

Press CTRL+SHIFT+: (COMMAND+; on the Macintosh).

Press ENTER (RETURN on the Macintosh).

Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 keyboard key


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 29, 1999