Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 79 - 2620_Birla Open Mind C-5
P. 79

    Select the cell or range of     1
                                cells and click on Home tab.                 Click on Delete down arrow.      2

                                                                                             Click  on  Delete   3
                                                                                             Cells option.

                                                                                             Choose an option by
                                                                                             clicking any one radio   4
                                                                                             button.

                                                                                                                    5
                                                                                             Click on OK button.

                                                                                         It  deletes  the  selected
                                                                                         cells. The cells on the right
                              It deletes the selected cells.                             are shifted to the left.
                              The cells below shift up.

                            It deletes the selected column.                              It deletes the selected row.
                            The columns on the right are                                 The row below shifts up.
                            shifted to the left.

                     Deleting an Entire Row or Column

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

                      2                              3
                          Click on Home tab.              Click on Delete down arrow.
                                                                                                      Select the Delete
                                                                                                      Sheet  Rows  or
                           Click  on  the                                                             Delete     Sheet
                           row or column                                                              Columns.            4
                           header of the
                           row or column
                       1   you  have to
                           delete.

                         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 selected 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 plus sign. This is called the

                     Fill Handle.

                                                                                        #Editing Cell Contents in Excel 2019  77

| 74 75 76 77 78 79 80 81 82 83 84 |