Microsoft Office Tutorials and References
In Depth Information
Decorating a Worksheet with Borders and Colors
Cell styles for quickly formatting a worksheet
A style is a collection of formats — boldface text, a background color, or a
border around cells — that can be applied all at once to cells without having
to visit a bunch of different dialog boxes or give a bunch of different
commands. Styles save time. If you find yourself choosing the same formatting
commands time and time again, consider creating a style. That way, you can
apply all the formats simultaneously and go to lunch earlier. Excel comes with
many built-in styles, and you can create styles of your own, as the following
Applying a built-in cell style
By way of the Cell Styles gallery, you can choose from any number of attractive
styles for cells in a worksheet. Excel offers styles for titles and headings, styles
for calling attention to what kind of data is in cells, and styles to accent cells.
Follow these steps to reformat cells by choosing a cell style:
1. Select the cells that need a new look.
2. On the Home tab, click the Cell Styles button.
As shown in Figure 4-4, the Cell Styles gallery opens.
3. Select a cell style.
The Cell Styles gallery is divided into categories. Scroll through the
categories until you find a style that suits your purposes.