Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 75 - 2610_Springdales_C-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 |