Page 74 - TP_iPlus_V2.1_Class7
P. 74

i +  MERGING CELLS

                  To merge cells, follow the given steps:

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


                  The cells will be merged in a row or column, and the cell content will be centred in the merged cell.
                  Split Cells

                  To split cells, follow the given steps:

                                    2  Click on the         3  Click on the arrow of the Merge & Center
                                   Home tab.               command on the Alignment group.





                                                                                 4  Select the Unmerge
                                                                                Cells option from the
                                                                                drop-down list..




                                                            1  Select the merged cell you want to split.

                  The cells will split, and the contents of the merged cell will appear in the upper-left cell of the
                  range of split cells.

                   i +  FORMATTING SPREADSHEETS

                  To further enhance your spreadsheet, you can format various elements, including text, numbers,
                  colours, and table styles.

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


                       2  Click on the Home tab.     3  Click on the Wrap Text command on the Alignment group.








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




                    72
                         iPlus (Ver. 2.1)-VII
   69   70   71   72   73   74   75   76   77   78   79