O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required