To Enter a Series of Data Using Fill Series in MS Excel
1. Type the first value in the series into a cell.
2. Type the second value into a cell below or to the right of the first cell.
3. Select the cells.
4. Drag the Fill Handle (a black square that appears at the bottom right corner of the last selected cell) over the cells into which you want to extend the series.