Add the Current Date in Excel

Excel Shortcut Keys Tutorial

By Ted French

Ads:

Excel Online Training

Spreadsheets

Excel Templates

MS Excel

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.

via Excel Shortcut Keys – Add the Current Date.