Sunday, April 18, 2010

Excel tip: Date, time insertion


Many people often use excel for various purpose. In any professional life in average 98% people use excel on daily basis.
Inserting current date and time is most often used functions. Let’s see the shortcuts to insert date and time in 3 different scenarios.
1.     Inserting Date: (Ctrl + ;)
To add the current date to a cell, begin by clicking on the cell where you want to date to be in your worksheet. Hold down the Ctrl key and hit the ; (semicolon) key. That will place the current date into any active cell.
Eg: 4/15/2010
2.     Inserting Time: (Ctrl + Shift + ;)
To insert the current time, click on the cell where you want to store the current time. Hold down both the Ctrl and Shift keys and press the ; (semicolon) key. That will place the current time into the cell.
Eg: 11:22 AM
3.     Inserting Date and Time:
To insert both the current date and the current time into the same cell, click on the cell where you want the date and time to be in your worksheet. Hold down the Ctrl key and press the ; key. Now, hit the space bar and hold down the Ctrl and Shift keys and press the ; key.
Eg: 4/15/2010  11:23:00 AM

Also,
·        To insert a dynamic date stamp into Excel, enter the following formula into any cell: =TODAY()
·         To insert a dynamic date and time stamp into Excel, enter the following formula into any cell: =NOW()

Depending on your need you can use any of the above options. 

No comments:

Post a Comment