How to use Autofill in excel || by Quicklink
Fill data automatically in worksheet cells
Select one or more cells you want to use as a basis for filling additional cells. For a series like 1, 2, 3, ..., type 1 and 2 in the first two cells. ...
Drag the fill handle .
If needed, click Auto Fill Options. and choose the option you want.