Microsoft Office Tutorials and References
In Depth Information
Formatting with cell styles
worksheet. Using such a style has no effect on any of the other five style attributes in cells
to which it is applied.
To specify style attributes, click the Format button to display the Format Cells dialog box,
where you can specify your formatting choices in detail. The Format Cells dialog box
contains six tabs corresponding to the six categories of style attributes; you can make as many
choices as you want on each tab. When you finish with the Format Cells dialog box, click
OK to close it and return to the Style dialog box. Then type a name in the Style Name box,
and click OK. Your custom style appears in the Custom category at the top of the Cell Styles
gallery, as shown in Figure 9-17, where you can see the Unlocked style we created.
For more information about the Format Cells dialog box, see “Formatting numbers” later in
Figure 9-17 Custom styles appear at the top of the Cell Styles gallery.
As you can see in Figure 9-17, you can right-click a cell style to display a shortcut menu you
can use to delete, modify, or duplicate the style. Duplication is handy if, for example, you
want to create a number of related styles with different ill percentages. Clicking the
Duplicate command makes it easier because it copies the other attributes for you—all you have
to do is change the ill percentage.
Creating cell styles by example If you formatted a cell using attributes you want to use
often, you can use the style-by-example procedure to encapsulate those attributes in a new