Datasheet

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 gal-
leries 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 thus use the same font or
fonts. Click the arrow on the drop-down box (called the font picker) in 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).
The following are characteristics of theme colors:
• The top row in a color picker displays the base theme colors, and the
next five rows display various tints and shades of the base colors.
Below the theme colors are standard colors that do not change if the
theme is changed. If you want to apply specific formatting that doesn’t
change after you change the theme, use a standard color.
• The first four colors on the picker (from the left), are intended for text
and background use. These colors are designed so that light text
always shows well on a dark background, and vice versa.
• The next six colors are used for accents. Most of the theme-style gal-
leries in Excel make extensive use of accent colors.
The two colors that are not exposed on the color pickers are used for
hyperlinks (not discussed in this book).
 Theme effect: Theme effects apply to graphic elements such as charts and
shapes and include three levels of styles for outlines, fills, and special
effects. Special effects include shadow, glow, bevel, and reflection.
Figure 1-8
16 Part 1: Getting to Know Excel 2007
03_046716 ch01.qxp 11/16/06 6:40 PM Page 16