Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 53 - 2617_JSSPS_C-5
P. 53

    Deleting an Entire Row or Column

                     To delete an entire row or column, follow the given steps:

                                                                                                     Click on Delete
                              Click on                                                                                    3
                          2   Home tab.                                                              drop-down arrow.

                          Click on the
                          row or column                                                              Select the
                          header of the                                                              Delete Sheet
                          row or column                                                              Rows or Delete
                      1   you want to                                                                Sheet Columns      4
                          delete.                                                                    option.

                     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. To use the Autofill feature, follow the given steps:                         Fill Handle

                           Type the first                                                          Click on Fill button.  3
                           number in a
                       1
                           series.

                           Select the cell                                                         Click on Series
                           and the cells                                                           option.           4
                       2   that you want
                           to AutoFill.

                     You can also change or select other values.

                                                                                    Enter the Stop    5

                               6   Click on OK                                      value.
                                   button.

                                                                                        Introduction & Editing in Excel  51

| 48 49 50 51 52 53 54 55 56 57 58 |