In this article we will learn about to fill a range with a series of Dates in Microsoft Excel 2010.
To filling a range with a series of dates you can use here “Auto Fill Option”. It appear when you drag any cell content down to the cells.A blue link get activated this is called “Auto Fill Option”.
Microsoft Excel has some inbuilt series such as Month, Week, Serial nos, date series etc.
When we fill the series of date, there is a possibility that it may be required date in series, month in series and year in series.
For the Month series Auto Filling option is already having the option for fill the series in month, date, and year.
Let’s take an example and understand how we can use Auto Fill option in Microsoft Excel.
We have date in Cell A1, now we want the date till the A10 cell in series.
To create the series follow below given steps:-
Note: If you want to fill the series of days, click on Fill Days. For the month series click on Fill Month and for the years click on fill Years.
This is how we can fill the range with a series of dates through Auto Fill option in Microsoft Excel 2010 and 2013.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.