AutoFill continues a series or pattern into the cells below. Please follow the steps below to use AutoFill to enter a series of values:
Step 1: Type the first a couple of rows or select the data on the top;
Step 2: Click the "Home" tab from the ribbon;
Step 3: Click "Fill" in the "Editing" section, and "Series" from the drop-down list;
Step 4: In the "Series" window, select "Columns" and "AutoFill" type;
Alternatively, select the top data (or type the data), drag down the handle in the right bottom corner when it turns into a black cross.
Step 5: Click "OK" at the bottom.