Page 26 - TP_Pluse_V2.2_Class_6
P. 26

The text in your cell will be wrapped.


                       Formatting Numbers                                                Text after wrapping

                  In Excel, the format of a cell is separate from the data that is
                  stored in the cell. This difference in the display 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.


                       Cell Borders                                                         Number Format options

                  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  existing  border  style,  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
                  Step 4:   Click  on the  border  style  you  would
                          like.  The border  will be  applied  to  the
                          selected cell or cell range. Cell borders                    Tech Hint
                          that  you  apply  appear on  printed          To apply a custom border style: click More
                          pages. If you do not use cell borders but     Borders. In the Format Cells dialog box,
                          want worksheet gridline borders for all       on the Border tab, under Line and Colour,
                          cells to be visible on printed pages, you     click  the line style  and colour that  you
                          can display  the gridlines  by  checking      want.
                          the Gridlines option from Show group
                          under View tab.
                  24    Plus (Ver. 2.2)-VI
   21   22   23   24   25   26   27   28   29   30   31