Page 65 - TGPT_V5.0_C5_Flipbook
P. 65
USING AUTOFILL FEATURE
The AutoFill 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
AutoFill 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 AutoFill feature, follow the given steps:
Click on Fill 3
button.
Type the first
1 number in a
series.
Click on Series
Select the cell option. 4
and the cells
2 that you want
to AutoFill.
You can also change or select other values. To do so:
Enter the Stop 5
value.
6
Click on OK button.
You can also use the AutoFill feature in a series. To do so:
Type the first two numbers in a series.
Select the cells and hover your mouse pointer over the bottom right corner of the selection.
Click and drag over the cells you want to autofill.
Introduction to Excel 2021 63

