How to Auto Fill in a Cell in Excel

1. Click the first cell that you want to include in the data range.
2. Type the first value for the series.
3. Type the second value in the next cell to establish a pattern.
4. Click the first cell and drag your mouse to the second cell to highlight both cells.
5. Hover your mouse over the Fill Handle, located in the lower-right corner of the highlighted cells.
6. Drag the Fill Handle across the range of cells that you want to auto fill.