• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Entering a Custom Series

If you want to create a series such as 10, 20, 30, where the series uses a custom increment between the values, you need to create a custom series. Excel provides two ways to create a custom series. To create a custom series using Fill, follow these steps:

  1. Enter the first value of the series into a cell.

  2. Enter the second value in the series into the next cell. For example, you might enter 10 into the first cell and then 20 into the second cell. This lets Excel know that the increment for the series is 10.

  3. Select both cells by clicking the first cell and dragging over the second cell.

  4. Drag the fill handle of the second cell to the other cells that will be part of the series. Excel analyzes the two cells, sees the incremental pattern, and re-creates it in subsequent cells.

You also can create a custom series using the Series dialog box. This enables you to specify the increment or step value for the series and even specify a stop value for the series.

  1. Enter the first value of the series into a cell.

  2. Select the cells that you want included in the series.

  3. Select the Edit menu, point at Fill, and then select Series. The Series dialog box opens (see Figure 3.7).

    Figure 3.7. The Series dialog box enables you to create a custom series.

  4. Enter the Step Value for the series. You also can enter a Stop Value for the series if you did not select the cells used for the series in step 2. For example, if you want to add a series to a column of cells and have clicked in the first cell that will receive a value, using a Stop Value (such as 100 for a series that will go from 1 to 100) will "stop" entering values in the cells when it reaches 100—the Stop Value.

  5. Click OK to create the series.

Tip

Different Series Types Not only can you create a linear series using the Series dialog box (as discussed in the steps in this section), but you also can create growth and date series. In a growth series, the data you're copying replaces any existing data in the adjacent cells that you fill.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint