Datasheet

16 Part 1: Getting to Know Excel 2010
is not what you wanted, and then committing to another option, only to realize
that you don’t like the new result either, and so on.
You find Live Preview options throughout Excel in places where formatting
alternatives are available — most notably in galleries.
Remember: Live Preview formatting is not universal in Excel. Some elements
provide formatting alternatives but do not have Live Preview support.
Formatting with Themes
In Excel, you can use a formatting concept known as a theme. A theme consists
of a combination of fonts, colors, and effects that provide a consistent look
among your workbook’s elements, including cells, charts, tables, and
PivotTables. You apply the theme’s fonts, colors, and effects through individual
options or the style galleries of the various elements.
Excel applies a default theme to all new workbooks along with a theme gallery
so that you can change the default theme. After you select a new theme, all
galleries and all the elements in your workbook formatted with theme styles
change to match the new theme.
Following is a description of the three parts of a theme:
✓ Theme font: A theme uses two complementary fonts — a header font and
a body font. All elements using themed styles use the same font or fonts.
Click the arrow on the drop-down box (the font picker) on the Ribbon’s
Home tab to see the fonts used in the theme currently applied to the
workbook.
✓ Theme color: A theme uses a matched set of twelve colors. Click the arrow
on the Fill Color or Font Color tool in the Font group of the Home tab to
see ten of the colors used in the theme currently applied to the workbook
(see Figure 1-8).
Figure 1-8
03_527559-ch01.indd 1603_527559-ch01.indd 16 4/1/10 6:59 PM4/1/10 6:59 PM