Microsoft Office Tutorials and References
In Depth Information
Formatting with cell styles
Themed Cell Styles These Accent and Emphasis styles are heavily dependent on
the current theme colors, offering four graduated percentages of each Accent color
for quartile comparisons.
Number Format Included for continuity, these styles are actually more accessible
using the Number buttons on the Home tab on the ribbon.
Custom This category does not appear in the gallery until you create a custom
style. After you do, the Custom category appears at the top of the gallery.
The Cell Styles gallery exhibits “mouse hover” functionality, letting you see a live preview
in selected cells on the worksheet when you rest the pointer on an item in the gallery. To
apply a style, select the cells you want to format, and click your chosen style in the gallery.
Creating custom cell styles
You can create your own styles using one of two methods: by modifying an existing style
or by clicking the New Cell Style command at the bottom of the Cell Styles gallery, which
displays the Style dialog box shown in Figure 9-16.
Figure 9-16 Use the Style dialog box to create your own cell styles.
The Style dialog box opens with the attributes of the default Normal style displayed. Styles
can have a minimum of one and a maximum of six sets of attributes: Number, Alignment,
Font, Border, Fill, and Protection, each with a corresponding check box in the Style dialog
box. Select the check boxes to specify the attributes you want for your cell style. For
example, you could clear all but the Protection check box to define a style that does nothing
more than change selected cells to “unlocked” status, allowing user entries on a protected