Page 71 - TP_Plus_v4_Class4
P. 71

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  69
   66   67   68   69   70   71   72   73   74   75   76