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.
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.
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,…|
Watch the training video: