Chat with us, powered by LiveChat

Set Theme Font in Excel

How to Apply Body and Heading Font Options in Excel

Excel has several built-in font sets that can be applied as a worksheet’s Theme Fonts. A font set consists of a Heading font and a Body font. Applying theme font sets helps you keep a consistent look and feel across different workbooks.

Apply a Theme Font Set

  1. Click the Page Layout tab.
  2. Click the Fonts button in the Themes group.
  3. Each font set shows the coordinating Heading and Body fonts it contains. Any text using theme heading and body fonts will be updated.

  4. Select a Font Theme.
    Apply a Theme Font Set

The text in the worksheet updates to use the new font set.

The text in the worksheet updates to use the new font set.

Create a Custom Font Set

  1. On the Page Layout tab, click the Fonts button in the Themes group.
  2. Select Customize Fonts.
    Create a Custom Font Set
  3. The Create New Theme Fonts dialog box opens, and you can specify your custom options.

  4. Set your Heading font.
  5. Set your Body font.
  6. Enter a Name for your font set.
  7. Once you’ve selected two fonts that look good in the preview and given the font set a name, you’re ready to save the font set.

  8. Click Save.
    Create a Custom Font Set

The worksheet’s fonts update to reflect the custom font set. If you click the Fonts button again, you can see your font set in the Custom section. It’s also available in other workbooks and even other Office applications.