Page 71 - TP_Pluse_V2.2_Class_5
P. 71
USING AUTO FILL FEATURE
The Auto Fill feature in Excel is used to automatically fill a series of data
in rows and columns based on the values of other cells. You can use the
Auto Fill feature to fill a series of numbers, days, months, hours, etc.
In Excel, when you hover your mouse on the bottom right corner of the
selected cell or range, the pointer changes to a plus sign. This is called the
Fill Handle.
To use the Auto Fill feature in a series, follow the given steps:
Step 1: Type the first two numbers in the series.
Step 2: Select the cells. Hover your mouse pointer over
the bottom right corner of the selection. 1
Step 3: Click and drag the mouse pointer over the
cells you want to Auto Fill. 2
Step 4: Release the mouse button.
The cells are filled with the series.
3 4
Alternate method
Step 1: Type the first number in the series.
Step 2: Select the cells that you want to Auto Fill.
Step 3: Click on Home tab.
Step 4: Click on Fill button in Editing group.
Step 5: Click on Series from the Fill drop-down menu.
Step 6: A Series dialog box opens. Enter the step value. You can also change or select other
values.
3 4
1
2
5
Step 7: Click on Ok. The cells are filled with the series.
Editing Cell Contents in Excel 2016 69

