Page 39 - modular4.0
P. 39

Chapter Profile

                        MERGING CELLS

                 To merge cells, follow the given steps:


                                           2  Click on Home tab.     3  Click on Merge & Center command.






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



                 Split Cell

                 To split a cell, follow the given steps:

                      2   Click  on
                      Home tab.                                                               3  Click on the arrow
                                                                                              button of the Merge
                                                                                              & Center command.
                     1  Select the
                     merged cell                                                              4   Select the
                     you want to                                                              Unmerge Cells
                     split.                                                                   option.



                        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:



                                                                                                     3  Click on Fill
                                                                                                     button.
                      1  Type the
                      first number
                      in a series.



                     2  Select the cell                                                              4   Click  on
                    and the cells                                                                   Series option.
                    that you want to
                    AutoFill.


                 You can also change or select other values.




                                                                                                 Editing in Excel 2019  37
   34   35   36   37   38   39   40   41   42   43   44