Page 75 - TP_iPlus_V2.1_Class7
P. 75

The text in your cell will be wrapped.











                 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
                 formats. To do so, follow the given steps:



                                                                                        1  Click on the cell(s)
                                                                                        that contains the
                                                                                        numbers that you
                                                                                        want to format.










                               2  Click on the arrow next to the Number Format box
                              on the Number group under the Home tab.




                                                                     4  Select
                                                                    the Number
                                                                    category.








                                                                   5  Click on the
                                                                  OK button.


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


                 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.




                                                                                                                  73
                                                                                          More on Spreadsheets
   70   71   72   73   74   75   76   77   78   79   80