Set Theme Font 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.

    Each font set shows the coordinating Heading and Body fonts it contains. Any text using theme heading and body fonts will be updated.

  3. Select a Font Theme.
    Apply a Theme Font Set

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

Create a Custom Font Set

If the built-in sets don't meet your needs, you can create a custom one. This can be especially helpful if oyu have specific company fonts that need to be used in your workbooks.

  1. On the Page Layout tab, click the Fonts button in the Themes group.
  2. Select Customize Fonts.
    Create a Custom Font Set

    The Create New Theme Fonts dialog box opens, and you can specify your custom options.

  3. Set your Heading font.
  4. Set your Body font.
  5. Enter a Name for your font set.
  6. 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.

  7. 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.

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you will consider our paid training.