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, ...

Get Microsoft® Office Excel 2003 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.