Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 66 - logicode 2609 C5
P. 66

    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, has 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.

                       64   Premium Edition-V

| 61 62 63 64 65 66 67 68 69 70 71 |