Topic 34: Changing and Customizing the Excel 2003 Sytles

[seema]

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.

Similar Threads:

• Topic 33: Discover the Amazing Power of Excel 2003 Data Analysis Tools!
• Topic 32: Adding and Customizing Excel Comments
• Topic 2: Start Exploring Microsoft Excel 2003

[seema]

To change the default Style in a workbook

From the Format menu, click Style. From the Style dialog box displayed, in the Style name box, select Normal. Click Modify ****on. 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 andfont size.

[seema]

To create and save custom styles

From the Format menu, click Style. OR press Alt+’ . From the Style dialog box displayed, in the Style name box, enter Negative Numbers with brackets, 0=-. Click Modify ****on. 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);- ; 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.