Microsoft Office Tutorials and References
In Depth Information
Applying Cell Styles
Figure 2-22
Cell Styles gallery
gallery of b uilt-in
styles
Live Preview of the
Heading 1 style
applied to cell A4
Headin g 1 selected
5. Move the pointer over different styles in the Cell Styles gallery to preview cell A4
with each style, and then click the Heading 1 style. The style is applied to cell A4.
6. Select the nonadjacent range B6:F6;B17:F17 , click the Cell Styles button, and
then click the Accent1 style in the Themed Cell Styles section. Each column
heading is formatted.
7. Select the nonadjacent range E7:F15;E18:F26 , click the Cell Styles button, and
then click the 20% − Accent1 style in the Themed Cell Styles section. The
calculated values are formatted differently from the data.
8. Click cell to deselect the range. See Figure 2-23. F1
Figure 2-23
Formatted yearly sales data
20% - Acc ent1 style
Heading 1 style
Accent1 style
Search JabSto ::




Custom Search