Page 69 - TGPT_V5.0_C5_Flipbook
P. 69

DELETING CELL CONTENTS


                 To delete the contents of a cell or a range of cells, select the cells and press the Delete key. The
                 contents of the cells get deleted.

                 Deleting Cells


                 To delete cells, follow the given steps:
                         Select the cell or range of      1           Click on  Delete drop-down        2
                         cells and click on Home tab.                 arrow.


                                                                                       Click  on  Delete   3
                                                                                       Cells option.



                                                                                       Click on the radio button
                                                                                       in front of Shift cells left   4
                                                                                       option.




                                                                                                              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 drop-down arrow.

                                                                                                  Select the Delete
                                                                                                  Sheet  Rows  or
                                                                                                  Delete     Sheet    4
                                                                                                  Column.







                                      Click  on  the  row or column  header of    1
                                      the row or column you have to delete.




                                                                                           Introduction to Excel 2021  67
   64   65   66   67   68   69   70   71   72   73   74