Add the Current Date in Excel
Excel Shortcut Keys Tutorial
By Ted French
Excel Online Training
Microsoft Excel 2010
“Use Shortcut Keys to Add the Current Date in Excel”
Use Shortcut Keys to Add the Current Date in Excel
© Ted French
This tutorial covers how to quickly add the current date to a worksheet using just the keyboard.
The key combination for adding the date is:
Ctrl + ; (semi-colon key)
Example: Using Shortcut Keys to Add the Current Date
To add the current date to a worksheet using just the keyboard:
Click on the cell where you want the date to go.
Press and hold down the Ctrl key on the keyboard.
Press and release the semi-colon key ( ; ) on the keyboard without releasing the Ctrl key.
Release the Ctrl key.
The current date should be added to the worksheet in the selected cell.
Note: This keyboard shortcut does not make use of the TODAY function so the date does not change every time the worksheet is opened or recalculated.