1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Add the Current Date in Excel

Excel Shortcut Keys Tutorial

By

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:

  1. Click on the cell where you want the date to go.

  2. Press and hold down the Ctrl key on the keyboard.

  3. Press and release the semi-colon key ( ; ) on the keyboard without releasing the Ctrl key.

  4. Release the Ctrl key.

  5. 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.

©2014 About.com. All rights reserved.