Page 75 - PlusGPT_V2.1_C7_Flipbook
P. 75

Inserting Rows/Columns

                 To insert a row in a worksheet, follow the given steps:
                 Step 1:   Click the row heading where you want to insert a new row.

                 Step 2:   Click on Insert command in the Cells group under the Home tab.
                 Step 3:   Select the Insert Sheet Rows option from the drop-down list. A new row is inserted above the
                          selected row and the existing rows shift downwards.













                 To insert a column in a worksheet, follow the given steps:
                 Step 1:     Click the column heading where you want to insert a new column.

                 Step 2:   Click on Insert command in the Cells group under the Home tab.
                 Step 3:   Click on Insert Sheet Columns. A new column is inserted to the left of the selected cells
                          and the existing columns shift rightwards.













                                                         Inserting a new column



                      Merging Cells
                 To merge cells, follow the given steps:

                 Step 1:    Select two or more adjacent cells that you want to merge.
                 Step 2:    Click on Merge & Center command in the Alignment group on Home tab.












                                                              Merging cells

                 The cells will be merged in a row or column, and the cell content will be
                 center aligned in the merged cell.

                                                                                                      Merged Cells

                                                                                          Introduction to Excel 2016  73
   70   71   72   73   74   75   76   77   78   79   80