Page 26 - Plus_V2.2_C6_Flipbook
P. 26

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.






















                                                               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,
                  colouring, 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.

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





















                                                           Text before wrapping
                  24    Premium Edition-VI
   21   22   23   24   25   26   27   28   29   30   31