Page 75 - Trackpad v5 class 5
P. 75

AUTOFILL

            Sometimes, while entering a large amount of data, we find that we are entering sequential
            data  in our worksheet which proves to  be  monotonous  and time-consuming.  Excel,

            however, is an excellent feature that provides the feature to add duplicate entries or to
            fill a series of data easily using the fill handle. The feature of entering sequential data in
            the cells of a worksheet is called Autofill. This feature allows us to quickly fill cells with
            repetitive or sequential data. Data can be filled down in a column or across a row.


            WHAT IS FILL HANDLE?

            When a cell is selected in a worksheet, a solid square called the Fill handle appears at the
            bottom-right corner of the cell. When we position our mouse pointer at the corner of the

            Fill handle, the shape of the mouse pointer changes to a Black cross icon. This black cross
            icon is used to fill cells with repetitive or sequential data.



                                          Fill Handle                                Black Cross Icon


            FILLING A NUMBER SERIES

            Let’s say we want to enter numbers in a sequence from 1 to 5 using the Fill handle.
            For filling data in a sequence from 1 to 5, follow the given steps:




                               1  Select the cell and the
                              numbers 1 and 2 in the first
                              two cells (A2 and A3).













                                                       3  Release the
                                                      mouse button.






                    2  Select both the cells and drag
                   the Fill Handle down to cover the
                   number of cells to be filled.

            The sequence will be completed automatically.



                                                                                          Editing in Excel 2021  73
   70   71   72   73   74   75   76   77   78   79   80