• 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 in 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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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