Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 16 - 2615_KEC
P. 16

    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.

                       14   Premium Edition-VI

| 11 12 13 14 15 16 17 18 19 20 21 |