Microsoft® Office Excel 2003 Inside Out

Formatting with Styles

Microsoft Excel's style feature allows you to assign names to combinations of formatting attributes. You can then apply those attributes by selecting the name from a list, which eliminates a lot of time clicking buttons, opening dialog boxes, and choosing individual options. Styles help you achieve consistency in formatting, both within a worksheet and across worksheets and workbooks. Using styles, you can easily modify the formatting characteristics of many cells at once.

Every new workbook contains six predefined styles:

• Comma. Number formatting only, with thousand separators and two decimal places.

• Comma [0]. Number formatting only, with thousand separators, rounded to the nearest integer.

• Currency. Number formatting only, ...