Page 72 - Trackpad_ipro 4.1_Class7
P. 72

Format 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. Excel provides 10 different
                  number formats which you can apply to the numeric values. It also allows you to create a custom
                  format. To do so, follow the given steps:

                                       1  Click on the cell(s) that contain(s)    2  Click on the arrow next to
                                       the numbers that you want to format.      the Number Format box.















                                                                 4  Select
                                                                 the Number
                                                                 category.








                       3  Click on the
                      More Number
                      Formats option to
                      see more details of                      5  Click on the
                      number formats.                         OK button.

                  Cell Borders

                  You can easily add a border around cell or cell range using predefined border styles. If none of
                  the available border options meet your needs, you can create a custom border also.

                  Apply Cell Borders

                  To apply a border to a cell, follow the given steps:


                                    2  Click on the
                                    Home tab.
                                                                                         3  Click the arrow next
                                                                                        to Borders command.



                                                                                         4  Click on the border
                            1  Select the cell or cell                                  style you would like.
                           range where you want to
                           add or change a border.







                    70     iPro (Ver. 4.1)-VII
   67   68   69   70   71   72   73   74   75   76   77