Microsoft Excel Training Online



Fill series in Excel for automating data entry






Fill series in Excel can be utilized for entering numbers, dates, or other built-in series items.
Select the Excel cell or cells that contain the starting values.
Drag the fill handle across the range that you want to fill. To fill in increasing order, drag down or to the right. To fill in decreasing order, drag up or to the left.
Example
Click on Edit in the Excel menu bar
Select Fill and then Series...
Select Date, Day, Step 1 and finally click OK.
As you can see in the Excel training video the cells get filled with consecutive dates. For different filling orders you need to change the step value , for example, to 2 to have alternate dates.

More examples
Using the fill handle you can quickly fill cells in a range with a series of numbers or with a built-in series for days, weekdays, months, or years.
Select the first Excel cell in the range that you want to fill.
Type the starting value for the series.
Type a value in the next cell to establish a series
For example, if you want the series 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. If you want the series 2, 4, 6, 8..., type 2 and 4. If you want the series 2, 2, 2, 2..., you can leave the second cell blank.
When you fill a series, the selections are extended as shown in the following table. Items separated by commas are placed in individual adjacent cells.


Initial selection Extended series
1, 2 3, 4, 5, 6,...
9:00, 10:00, 11:00, 12:00,...
Mon, Tue Wed, Thu,...
Monday, Tuesday, Wednesday, Thursday,...
Jan, Feb, Mar, Apr,...
Jan, Apr, Jul, Oct, Jan,...
Jan-2008, Apr-2008, Jul-2008, Oct-2008, Jan-2009,...
15-Jan, 15-Apr 15-Jul, 15-Oct,...
1999, 2000 2001, 2002, 2003,...
1-Jan, 1-Mar 1-May, 1-Jul, 1-Sep,...
Qtr3 Qtr4, Qtr1, Qtr2,...
text1, textA text2, textA, text3, textA,...
1st Period 2nd Period, 3rd Period,...
Product 1 Product 2, Product 3,...

Select the Excel cell or cells that contain the starting values.
Drag the fill handle across the range that you want to fill.
To fill in increasing order, drag down or to the right. To fill in decreasing order, drag up or to the left.

Tips
You can also specify the type of series by using the right mouse button to drag the fill handle over the range and then clicking the appropriate command on the shortcut menu. For example, if the starting value is the date JAN-2002, click Fill Months for the series FEB-2002, MAR-2002, and so on; or click Fill Years for the series JAN-2003, JAN-2004, and so on.If the selection contains numbers, you can control the type of series that you want to create.
On the Edit menu, point to Fill, and then click Series. Under Type, specify the options that you want to use.
A Linear series is calculated by adding the value in the Step Value box to each cell value in turn.
A Growth series is calculated by multiplying the value in the Step Value box by each cell value in turn.
An Auto Fill series produces the same results as dragging the fill handle.

Fill series in Excel