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:
- Click on the cell where you want the time to go.
- Press and hold down the Ctrl and the Shift keys on the keyboard.
- Press and release the colon key ( : ) on the keyboard without releasing the Ctrl and Shift keys.
- 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.