Search This Blog

August 7, 2014

How to add current time to worksheet/Ms-excel Using Shortcut Keys




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/Ms-excel 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.

No comments:

Post a Comment

Earn Money From Home