Page 27 - Plus_V2.2_C6_Flipbook
P. 27

Step 2:  Click on Wrap Text command from Alignment group under Home tab.

                 The text in your cell will be wrapped.



                                                                         Text after wrapping
                      Formatting Numbers

                 In Excel, the format of a cell is separate from the data that is
                 stored in the cell. This display difference can have a significant
                 effect when the data is numeric. Follow the below steps to
                 format numbers:

                 Step 1:    Click the cell(s) which contains the numbers that you
                         want to format.

                 Step 2:   Click the arrow next to the Number Format box in
                         the Number group under Home tab and then click
                         the format that you want.

                 Step 3:   Click on More Number Formats option to see more

                         details of number formats.
                                                                                         Number Format options
                      Cell Borders

                 By using predefined border styles, you can quickly add a border around cells or ranges of cells. If the
                 listed cell borders do not meet your needs, you can create a custom border.


                 Apply Cell Borders

                 Follow the below steps to apply cell border:

                 Step 1:    In a worksheet, select the cell or range of cells that you want to add a border to, change the
                         border style on, or remove a border from.
                 Step 2:  Go to the Font group in the Home tab.
                 Step 3:  Click the arrow next to Borders command.





















                                                          Applying cell borders


                                                                                              More on Excel 2016   25
   22   23   24   25   26   27   28   29   30   31   32