How to Apply a Theme to a Worksheet

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.

...
Excel's "Page Layout" includes a gallery of document themes for a worksheet.

Step

Open the Excel worksheet.

Step

Click the “Page Layout” tab on the command ribbon.

Step

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

Step

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

Step

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

Step

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