Saving Formats As Named Styles

Although Excel's named styles are considerably less versatile than their equivalents in Word, you can still use this feature to reuse favorite formats. By default, every new workbook includes a set of predefined formats in the following named styles: Normal, Percent, Currency, Comma, Currency [0], and Comma [0]. (The two styles followed by [0] show whole numbers only rather than two decimal places.)

TIP FROM

The Currency, Percent, and Comma buttons on Excel's Formatting toolbar actually apply the corresponding named styles. If you want to redefine any of these buttons, just redefine that style. The Currency button, for example, applies the Accounting format with two decimal places to the selected cell or range. To change the way the Currency button works, redefine the Currency named style so that it uses a Currency format, if you want. Likewise, you can change the named Percent style to include one or two decimal places, if you prefer. See Chapter 24, “Excel Essentials,” for instructions on how to save these changes as part of the default workbook format so that they are available for every new workbook you create.