Fill a column with a series of numbers
- Select the first cell in the range that you want to fill.
- Type the starting value for the series.
- Type a value in the next cell to establish a pattern. …
- Select the cells that contain the starting values. …
- Drag the fill handle.