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