Create a Linear Series of Values in Excel


Here’s how to use Auto Fill to create a series of values:

  1. Create the initial series. In a Microsoft Office Excel workbook, type 1 in the A1 cell and 2 in the A2 cell.
  2. Select cells A1 and A2.
  3. Click the Auto Fill handle (the little black box in the lower-right corner of the selection) and drag to A15 to fill the cells with the numbers 1 through 15. You can create different series of numbers, odd and even numbers, or even dates.

See the Video Below