Microsoft Office Tutorials and References
In Depth Information
Applying Cell Styles
Applying Cell Styles
A workbook often contains several cells that store the same type of data. For example,
each worksheet might have a cell displaying the sheet title, or a range of ﬁ nancial data
might have several cells containing summary totals. It’s good design practice to apply the
same format to worksheet cells that contain the same type of data.
One way to ensure that you are using consistent formats is to copy and paste your
formats using the Format Painter. The Format Painter is effective, but it can also be time
consuming if you need to copy the same format to several cells scattered across the
workbook. Moreover, if you decide to modify the format, you must copy and paste the
revised format all over again. Another way to ensure that cells displaying the same type
of data use the same format is with styles.
A style is a selection of formatting options using a speciﬁ c font and color from the
current theme. For example, you can create a style to display sheet titles in a bold, white,
20-point Calibri font on a blue background. You can then apply that style to any sheet
title in a workbook. If you later revise the style, the appearance of any cell formatted
with that style is updated automatically. This saves you the time and effort of reformatting
each cell individually.
Excel has a variety of built-in styles to format worksheet titles, column and row totals,
and cells with emphasis. You used the built-in Currency and Percent styles when you
formatted data in the Yearly Sales worksheet as currency and percentages. Some styles are
based on the workbook’s current theme and may change if the theme is changed.
Applying a Cell Style
• Select the cell or range to which you want to apply a style.
• In the Styles group on the Home tab, click the Cell Styles button.
• Point to each style in the Cell Styles gallery to see a Live Preview of that style on the
selected cell or range.
• Click the style you want to apply to the selected cell or range.
You will use some of the built-in styles to add more color and visual interest to the
Yearly Sales worksheet.
To apply built-in styles to the Yearly Sales worksheet:
1. If you took a break after the previous session, open the ExerComp Sales Report
workbook located in the Excel2\Tutorial folder included with your Data Files.
2. Click the Yearly Sales sheet tab to make that worksheet active, and then select
the merged cell .
3. In the Styles group on the Home tab, click the Cell Styles button. The Cell Styles
4. Point to the Heading 1 style in the Titles and Headings section. Live Preview
shows cell A4 in a 15-point, bold font with a solid blue bottom border. See