Page 70 - TP_Pluse_V2.2_Class_5
P. 70

Or

                            Right-click  and  choose  Delete  option  from the
                          context menu.
                          A Delete dialog box with four options appears.            a                               4
                                                                                    b
                          a.  Shift cells left: deletes  the  selected cells and
                             shifts the cells on the right to left.                 c
                                                                                    d
                          b.  Shift cells up: deletes the selected cells. The cells
                             below shift up.                                        5

                          c.  Entire  row: deletes  the  selected  row. The row
                             below shifts up.
                          d.  Entire column: deletes the selected column and shifts

                             the column on the right to left.
                  Step 4:   Click on the radio button before Shift cells left option.

                  Step 5: Click on Ok button.

                  The selected cells are deleted and the cells on the right move to the left. In the given screenshot,
                  the cells have moved from column C to column B.

                       Deleting an Entire Row or Column

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

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

                             2

                                                                                                          3
                                                                                                          4



                             1





                  Step 2:  Click on Home tab.

                  Step 3:   Click on Delete drop down menu in
                          Cells group. A list of options appears.

                  Step 4:   Select the Delete Sheet Rows or Delete
                          Sheet Columns.

                  The selected row or column is deleted. The row below or the column on the right shifts to fill
                  the space.




                  68    Plus (Ver. 2.2)-V
   65   66   67   68   69   70   71   72   73   74   75