Page 75 - C_GPT _V4 _class_5
P. 75

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 (+) sign. This feature is called
                 Fill Handle. To fill a series using the Fill Handle, drag the plus (+) sign to the
                 desired cell.                                                                              Fill Handle

                 To use the Autofill feature, follow the given steps:






                       Type the first                                                          Click on Fill button.  3
                       number in a
                   1
                       series.


                       Select the cell
                       and the cells                                                           Click on Series   4
                   2   that you want                                                           option.
                       to AutoFill.




                 You can also change or select other values.












                                                                                Enter the Stop    5

                               Click on OK                                      value.
                           6
                               button.




                          Art Integration Learning
                                                                                                          Lab Activity

                   Create a worksheet for the list of students who are interested for the 'Traditional dress competition'.

                                      Name                        Dress                 State representing












                                                                                Editing Cell Contents in Excel 2019  73
   70   71   72   73   74   75   76   77   78   79   80