Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 35 - 2611_SmartGPT Pro V(5.0) C-5
P. 35

    Alternatively, select the cell and press the Delete key.

                                              Fill in the blanks.
                             uiz   Bee        a.  _________ command reverses any action performed by us.
                                              b.    _________ option reverses back the action performed using the

                                                 Undo option.

                               DELETING CELLS, ROWS OR COLUMNS

                     We can delete unwanted rows and columns from our worksheet. To delete any rows or
                     columns, follow the given steps:

                                                          2  Choose Delete option.

                                                                                               Short key
                                                 2  Choose                                        To delete a row or
                                                                                                  column:
                                                Delete option.

                        1  Select a column  to  be          1  Select a row to be deleted             Ctrl   +   –
                       deleted and right-click on it.      and right-click on it.

                               INSERTING CELLS, ROWS OR COLUMNS

                     We can insert cells, rows and columns in Excel 2021.

                     INSERTING ROWS
                     To insert a row in the worksheet, follow the given steps:

                                                                    1  Right-click  on the  row or
                                                                    column number above or below
                                                                    where you  want to  add  a new
                                                                    row and select Insert option.

                     A new row will be inserted above the selected row.

                     Alternatively, click on the down arrow of the Insert option present in the Cells group under
                     the Home tab, and select the Insert Sheet Rows option from the drop-down list.

                                                                                                           Excel 2021  33

| 30 31 32 33 34 35 36 37 38 39 40 |