Microsoft Excel offers powerful features on handling different kind of data information. For example, when we need enter date values in Excel cells, we do not need enter all the numbers in Excel cell. In Excel worksheet, there are some quick tricks for entering dates, especially if there’s some kind of pattern to the date values you’re entering. This post explains how to use these simple tricks to enter date values quickly and intuitively into Microsoft Excel.
Some basic tricks you might already know. For instance, press [Ctrl] + “;” (semicolon) can fast enter the current date. Copy that single date by using fill handle can create a date series. Through the fill handle, we can increase the date by one day. If we enter 2012/7/6 and use the fill handle to create a date series, it will end up with 2012/7/6, 2012/7/7, 2012/7/8, and so on.
The fill handle feature provides a lot of built-in flexibility. If you know how to access it, you can save yourself much time. Now, let’s try these tricks.
1. Select a cell and press [Ctrl] + “;” to enter the current date.
2. Right-click mouse button to the fill handle and drag down several cells and release. After that, Excel displays a context menu. Or left click mouse button and drag the fill handle down several cells and release, click “Auto Fill Option” button.
Some basic tricks you might already know. For instance, press [Ctrl] + “;” (semicolon) can fast enter the current date. Copy that single date by using fill handle can create a date series. Through the fill handle, we can increase the date by one day. If we enter 2012/7/6 and use the fill handle to create a date series, it will end up with 2012/7/6, 2012/7/7, 2012/7/8, and so on.
The fill handle feature provides a lot of built-in flexibility. If you know how to access it, you can save yourself much time. Now, let’s try these tricks.
1. Select a cell and press [Ctrl] + “;” to enter the current date.
2. Right-click mouse button to the fill handle and drag down several cells and release. After that, Excel displays a context menu. Or left click mouse button and drag the fill handle down several cells and release, click “Auto Fill Option” button.
3. Select the appropriate option. For instance, choose Fill Months to increase the month value in your date series.
By using these Excel tricks to fast enter date values can save us a lot of time on daily work. Wish this post is useful for all of you.