Page 57 - TP-Play_V-2.0_Book-5
P. 57

Step 2   Click on Merge & Center command in the Alignment group on Home

                     tab.






                                                2

                                    1
                                             Merging cells

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


            To split a cell, follow the given 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 under Home tab.

            Step 3   Select the Unmerge Cells option. The cells will split and the contents of
                     the merged cell will appear in the upper-left cell of the range of split cells.

                                                          2








                                                          3
                                          1

                                                       Splitting cells

                AUTOFILL

            AutoFill feature automatically fills a series of data in your worksheet. It saves your
            time to complete the text or number series for you. To use AutoFill feature, follow

            the given steps:
            Step 1  Enter the first two numbers you want to start the series with.

            Step 2  Select both the cells containing the numbers you have entered.

            Step 3   Position the mouse pointer over the bottom right corner of the last selected
                     cell. The pointer changes to (+) sign.

            Step 4   Drag the mouse pointer over the cells you want to include in the series. The
                     cells display the number series automatically.


                                                                                   Editing in Excel 2016     57
   52   53   54   55   56   57   58   59   60   61   62