Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 29 - 2629_Devagiri_C-6
P. 29

    5    Type your custom list   6    Click on the
                                                                             items in the List entries   Add button to save
                                                                           box, separated by commas.     the custom list.

                          3    Click on the      4    Click on the Edit                  7    Click on the OK button.
                        Advanced option.       Custom Lists option in
                                                the General section.

                     Again, click on the OK button in the Excel Options dialog box.

                     Now, if you type North in a cell and drag the fill handle, Excel will automatically
                     complete the series as North, South, East, West.

                            FORMATTING TEXT IN A WORKSHEET

                     Formatting text in a worksheet involves changing how the text appears to make it easier to read
                     and more visually appealing.
                     In Excel, you can apply a variety of formatting options, which are as follows:
                      Formatting Option                             Description                                 Icon

                     Font Styles            Choose  from font styles like  Arial, Times  New  Roman or
                                            Calibri to modify text appearance.

                     Font Size              Adjust font size for headings or details; the default size is 11.

                     Bold (B)               Makes text darker and thicker to highlight important data.

                     Italic (I )            Slants text to the right for emphasis or differentiation.

                     Underline (U)          Adds a line beneath text to highlight key data.

                     Font Color             Changes the text colour to emphasise or match the theme.

                     Text Alignment         Controls text position within a cell with horizontal alignment
                                            (Left, Center,  Right)  and vertical  alignment  (Top, Middle,
                                            Bottom).

                                                                                                                      27
                                                                                                         Explore Excel

| 24 25 26 27 28 29 30 31 32 33 34 |