Page 35 - TP_Prime_v2.2_Class_6
P. 35

Splitting Cells


                 Splitting cells means to separate two cells that were previously merged. To split merged
                 cells, follow these 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 on

                          Home tab.

                 Step 3:  Select the Unmerge Cells option.                                                                  MORE ON EXCEL










                                                                                                                          33










                                                            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.



                   Formatting Spreadsheets


                 To further enhance your spreadsheet, you can format a number of elements such as text,
                 numbers, cell styles, and table styles.


                 Wrap Text


                 You can display multiple lines of text inside
                 a cell using Wrap Text feature. Wrapping
                 text in a cell does not affect other cells.
                 To do so, follow these steps:

                 Step 1:   Click on the cell in which you want
                          to wrap the text.

                 Step 2:   Click on the Wrap Text command
                          from Alignment group under Home                         Text before Wrapping

                          tab.
   30   31   32   33   34   35   36   37   38   39   40