Page 80 - Trackpad_V2.1_Class5
P. 80

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.



                   78   Trackpad (V2.1)-V
   75   76   77   78   79   80   81   82   83   84   85