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
   60   61   62   63   64   65   66   67   68   69   70