Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells. Watch this video from community expert Mike Girvin to learn how.
Select the cell or cells you want to use as a basis for filling additional cells.
Note: If you want a series like 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. If you want the series 2, 4, 6, 8..., type 2 and 4. If you want the series 2, 2, 2, 2..., you can leave the second cell blank.
Drag the fill handle .
If needed, click Auto Fill Options , and choose the option you want.