Excel Fill Series

Excel Fill Series

For example, we want to create a list of dates from 01/01/2015 to 12/31/2015. We can type the date 01/01/2015 in cell A1 and then drag it down until we reach 12/31/2015. It will take some time as it’s difficult to stop the mouse at exactly the right cell.

So an option is to use the fill series option. The series dialog box has many options and some of them get automatically selected as the selected cell in our case has a date. If the value in the first cell is a number then we’ll see the ‘Date unit’ options are greyed out:

As we want to fill dates down column A, so we need columns selected.

--Type as Excel detected is Date.

--It has also assumed that we want to increase series by days, as opposed to weekdays, months or years.

--And the step value or increment value is one day at a time.

--So I need to enter the stop value which is last date of my series which in our case is 12/31/2015.

Click ok and you will have a list of dates from January 1 2015 to December 31, 2015 in a few clicks.

Note: (I learned it from http://www.myonlinetraininghub.com/)