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
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.
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.
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
OR press Alt+’ .
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!