Site icon ExcelNotes

How to Use AutoFilll to Enter a Series of Values

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.

Exit mobile version