711
Saving Formats as Named Styles
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.)
25
You can create named styles using any format you want. This technique is a great time-
saver if you continually find yourself applying the same formatting options to new work-
sheets:
1.