Page 52 - TechPluse_C6_Flipbook
P. 52

Step 1     Select two or more adjacent cells that you want to merge.

                  Step 2     Click on the Format menu.
                  Step 3     Select the Merge Cells → Merge and Center Cells option.
                  Step 4     The cells will be merged in a row or column and the cell contents will be centered in
                             the merged cell.








                                                                                 Unmerged Cells








                                                                                  Merged Cells

                                     Merging cells
                   Tech


                     Funda

                                   Click on the Merge & Center command (            ) to merge the selected
                                   cells and align cell contents to the center of the merged cells.


                      SPLITTING CELLS

                  Calc also allows you to split the merged cell

                  into multiple cells. Perform the following steps
                  to split the selected cell:
                  Step 1   Select the merged cell you want to

                            split.
                  Step 2   Click on the Format menu.
                  Step 3    Select  the  Merge  Cells  →  Split

                            Cells  option.  The  cell  will  split  and
                            the contents of the merged cell will
                            appear in the upper-left cell of the
                                                                                        Splitting cell
                            range of split cells.
                      FORMATTING SPREADSHEETS


                  To further enhance your spreadsheet, you can wrap your text according to the content of the
                  cell, apply border and style to the cells, add background colour to a cell and change the colour
                  of text.



               50       Premium Edition-VI
   47   48   49   50   51   52   53   54   55   56   57