Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 63 - logicode 2609 C5
P. 63

    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                                        To delete a row or
                                                Delete option.                                 Short key  column:

                                                 2  Choose                                            Ctrl   +   –
                                                Delete option.

                        1  Select a column  to  be          1  Select a row to be deleted
                       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:

                                                                                               2  Select the
                                                                                              desired option.

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

                     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.

                                                                                                   Editing in Excel 2021  61

| 58 59 60 61 62 63 64 65 66 67 68 |