Microsoft Office Tutorials and References
In Depth Information
Formatting with cell styles
style. For example, suppose you format a cell with right alignment and 18-point Arial Black.
To make this combination of attributes a new style, follow these steps:
Select the cell that contains the formatting you want.
On the ribbon, click Home, Cell Styles, New Cell Style.
Type a name such as HeadRight in the Style Name box.
Clear the Number, Border, Fill, and Protection check boxes in the Style Includes area,
and click OK. The new style then appears in the Cell Styles gallery.
The safest way to create a style by example is to select only one cell—one you know
has all the attributes you want to assign to the new style. If you select two or more cells
that are not formatted identically, the new style assumes only those attributes that all
cells in the selection have in common.
Modifying and duplicating cell styles The principal advantage of using styles is that if
you change your mind about the appearance of a particular element in your workbook,
you can revise every instance of that element at once by changing the style. For example,
if you’d like the font in the custom HeadRight style—which is now 18-point Arial Black—to
also be italic, you can redefine HeadRight.
To modify a style definition, follow these steps:
Click Home, Cell Styles.
2. Right-click the thumbnail for the style (in this case, HeadRight) in the gallery, and
click Modify to display the Style dialog box.
Click the Format button to display the Format Cells dialog box, and select the
appropriate format options, as shown in Figure 9-18. (For this example, click the Font
tab, and select the Italic option in the Font Style list.)
4. Click OK to return to the Style dialog box, and then click OK to confirm your changes.
You can also right-click an existing style and click the Duplicate command, which opens a
Style dialog box similar to the one shown in Figure 9-18 and appends a number to the end
of the style name. You can then change the name if you like and click the Format button to
make adjustments to the formatting attributes. Using Duplicate is helpful when you want
to create a number of similar styles or when you want to base a custom style on one of the