How to Apply a Theme to a Worksheet

By Kathryn Hatashita-Lee

Microsoft Excel 2010 can format a worksheet and its data to create a custom look. Excel's "Page Layout" includes a combination of colors, fonts and effects to produce a theme, such as "Newsprint" or "Clarity." The "Theme Colors" feature color palettes for text, background accent and hyperlinks. "Theme Fonts" apply to the heading and body text. "Theme Effects" apply to fill and line effects.

Step 1

Open the Excel worksheet.

Step 2

Click the "Page Layout" tab on the command ribbon.

Step 3

Click "Themes" in the "Themes" group. A gallery of "Built In" theme samples appears.

Step 4

Point over the theme samples to preview the effect. The column and row headers also change in format.

Step 5

Click the preferred document theme. Examples include "Concourse" with red hyperlinks and "Newsprint" with "Times New Roman" fonts.

Step 6

Type the data in the worksheet. The data formats with the preferred theme.

Tips & Warnings

  • The "Themes" group includes separate commands for "Theme Colors", "Theme Fonts" and "Theme Effects." You can opt to select, save and name a custom theme of preferred "Color" and "Font" elements. The "Theme Effects" cannot change, but you can select a pre-designed effect for a custom document theme.