Page 38 - TP_Modular_V2.1_Class7
P. 38

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

                                    What if you could use Excel to track the books you’ve read and the books
                                    you want to read? How would you rate them and what genres would you
                                    include?


                      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.
                  Split Cell                                                                           Merged Cells

                  To split a cell, follow the given steps:

                  Step 1    Select the merged cell you want to
                           split.
                  Step 2    Click on the arrow of the Merge &
                           Center command in the Alignment
                           group under Home tab.
                  Step 3     Select  the  Unmerge Cells option.                        Splitting cells
                           The cells will split and the contents of the merged cell will appear in the upper-left cell
                           of the range of split cells.


                   36       Modular (Ver. 2.1)-VII
   33   34   35   36   37   38   39   40   41   42   43