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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.