Page 36 - TP_Prime_v2.2_Class_6
P. 36

The text in your cell will be wrapped.








                                                          Text after Wrapping

                   Format Numbers

           Prime (Ver. 2.2)-VI  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 on the cell(s) which contains the numbers
                           that you want to format.
          34
                  Step 2:   Click on 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
                                                                                           Number Format options
                           more details of number formats.


                   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

                  To apply borders to cell, follow these steps:

                  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.

                  Step 4:   Click on the border style you would like. The border will be applied to the selected
                           cell or cell range. Cell borders that you apply appear on printed pages. If you do
   31   32   33   34   35   36   37   38   39   40   41