Page 73 - iPlus_Ver_2.0_class_7
P. 73

i +  MERGING CELLS

                 To merge cells, follow the given steps:

                                2  Click on the
                                Home tab.
                                                                                              3  Click on the
                                                                                             Merge & Center
                         1  Select two or more
                                                                                             command.
                        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
                                 Home tab.                 Merge & Center command.







                                                                                 4  Select the Unmerge
                                                                                Cells option.




                                                           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 a number of elements such as 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.








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




                                                                                                                  71
                                                                                          More on Spreadsheets
   68   69   70   71   72   73   74   75   76   77   78