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

Adding the Current Time

Excel Shortcut Keys Tutorial

By

Use Excel Shortcut Keys to Add the Current Time

Use Excel Shortcut Keys to Add the Current Time

© Ted French

This tutorial covers how to quickly add the current time to a worksheet using just the keyboard:

The key combination for adding the time is:

 Ctrl  + Shift  +  :  (colon key)  

Example: Using Shortcut Keys to Add the Current Time

To add the current time to a worksheet using just the keyboard:

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

  2. Press and hold down the Ctrl and the Shift keys on the keyboard.

  3. Press and release the colon key ( : ) on the keyboard without releasing the Ctrl and Shift keys.

  4. The current time will be added to the spreadsheet.

Note: This keyboard shortcut does not make use of the NOW function so the date does not change every time the worksheet is opened or recalculated.

Other Shortcut Keys Tutorials

©2014 About.com. All rights reserved.