1. Select the first cell in the range that you want to fill.

  2. Type the starting value for the series.

  3. On the Home tab, in the Editing group, click Fill, and then click Series.

    Excel  Ribbon Image

  4. Under Type, click one of the following options:

    • Linear Creates a series that is calculated by adding the value in the Step value box to each cell value in turn.

    • Growth Creates a series that is calculated by multiplying the value in the Step value box by each cell value in turn.

    • Date Creates a series that fills date values incrementally by the value in the Step value box and is dependent on the unit specified under Date unit.

    • AutoFill Creates a series that produces the same results as dragging the fill handle.

  5. To establish a pattern for the series, in the Step value and Stop value boxes, type the values you want.

Examples of series that you can fill

When you fill a series, the selections are extended as shown in the following table. In this table, items that are separated by commas are contained in individual adjacent cells on the worksheet.

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-07, Apr-07

Jul-07, Oct-07, Jan-08,...

15-Jan, 15-Apr

15-Jul, 15-Oct,...

2007, 2008

2009, 2010, 2011,...

1-Jan, 1-Mar

1-May, 1-Jul, 1-Sep,...

Qtr3 (or Q3 or Quarter3)

Qtr4, Qtr1, Qtr2,...

text1, textA

text2, textA, text3, textA,...

1st Period

2nd Period, 3rd Period,...

Product 1

Product 2, Product 3,...