Excel Styles and Custom Formatting

This article let you understand the different between Excel styles and Excel custom formatting.

When you format a cell in a worksheet, you can define cell shading, font color, font, font size, borders, and much, much more. In short, there are many definitions that can be set for a single cell.

You save all the formatting you have customized. The main limitation is that all custom formatting is only saved in the current workbook. Without defining a name for the format, it will be difficult for you to find and reuse it.

Furthermore, when using this method, you cannot save definitions such as font, patterns, borders and any of the wide variety of formatting options in the Format Cells dialog box.

Then the Excel Styles are different!

Changing the definitions of the style will modify the default format of text or numbers in the workbook.

To change the default Style in a workbook

  • From the Format menu, click Style.

    style dialog box

  • From the Style dialog box displayed, in the Style name box, select Normal.
  • Click Modify button.
  • From the Format Cells dialog box displayed, do the necessary adjustments.
    Number tab: Set the number format that appears in the cells.
    Alignment tab: Change the vertical and horizontal alignments of the text/number in the cells.
    Font tab: Change the font pattern, style, color of the text/number in the cells.
    Border tab: Add or remove the border of the cells.

  • Click OK.

    The formatting suggested by default in the workbook allows you to enter both text and numbers into cells. Formatting a cell for text only by selecting the Text format from the list of standard formats appearing in the Category box in the Number tab of the Format Cells dialog box will allow only text and not numbers to be displayed in the cell. The opposite is also true. If you format a cell for numbers only, you will not be able to display text in the cell.

    Actually, in the Style dialog box, you can create a wide range of complex styles and save each one separately with a unique name. These styles can then be applied repeatedly.

    The example below shows you how to format a number so that a negative number displayed in brackets and zero (0) is replaced with a dash (-). Choose the font and font size.

    To create and save custom styles

  • From the Format menu, click Style.
    OR press Alt+’ .

    modify style

  • From the Style dialog box displayed, in the Style name box, enter Negative Numbers with brackets, 0=-.
  • Click Modify button.
  • From the Format Cells dialog box displayed, select the Number tab, and in the Category: box, select Custom.In the Type: box, change and type in the following number format #,##0 ;[Red](#,##0);- ;

    format cells - custom

  • Select the Font tab.
  • In the Font: box, select Arial. In the Font style: box, select Regular, and in the Size: box, select 10.
  • Click OK.
  • In the Style dialog box, click OK.

    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

    Can't find what you're looking for? Try Google Search!


    Back to Top

    >> Next Topic : Use the Excel SUMIF Function Correctly!

    << Previous Topic : Discover the Amazing Power of Excel 2003 Data Analysis Tools!

    You're viewing the Excel styles info page, click here to go back to the Home Page