Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 37 - 2629_Devagiri_C-6
P. 37

    To insert a row in a worksheet, follow the given steps:  To delete a cell, follow the given steps:

     2    Click on the Insert down arrow.         2    Click on the Delete down
                                                   arrow in the Cells group.

     3    Select the Insert
     Sheet Rows option.

                                                                                                 4    Choose either Shift
                                                                                                 cells left or  Shift cells
                                                         3    Select the Delete                  up to fill the gap.
                                                            Cells option.

     1    Select the row above which
     you want to insert a new row.  1    Select the cell or range of         5    Click on the OK button.
                                cells you want to delete.
     A new row will be inserted above the selected row.
     Similarly, you can insert a column by selecting a column and choosing the Insert Sheet Columns   DELETING ROWS OR COLUMNS

     option. The new column will be inserted to the left of the selected column.
                     You can delete entire rows or columns in Excel if you no longer need them.
     RAPID RECALL  Tick ( ) if you know this.  To delete a row or column, follow the given steps:

                                                  2    Click on the Delete down arrow.
     1.  You can easily add, rename or delete worksheets to organise your data better.
     2.  You can relocate a worksheet to a different position within the same workbook

     or transfer it to another workbook.

     DELETING CELLS, ROWS AND COLUMNS

     In Excel, you  can  quickly  delete  cells, rows or columns  to
     clear unwanted data and maintain a clean, well-organised
                                                           3    Select Delete Sheet
     worksheet.        1    Select the row heading/column   Rows/Delete Sheet Columns
                         heading you want to delete.
                                                          from the drop-down list.
     DELETING CELLS
     You  can delete  a cell or a range of cells in Excel and the   The row or column will be removed and the remaining data will adjust accordingly.
     surrounding data will shift accordingly to fill the space.

     SHORT SIGN             MERGING CELLS

                     When you want to combine two or more cells in Excel, you have three options. Each option will
     To delete a row or
     column: Ctrl + -  merge cells in different ways. These options are as follows:
                         Merge & Center: Merges the selected cells and centres the content within the merged cell.

                                                                                                                      35
                                                                                                         Explore Excel

| 32 33 34 35 36 37 38 39 40 41 42 |