Sometimes, we don’t like our default theme font in Excel. Excel gives us a platform where we change the theme font and at the time, we can customize the theme font. We have several in-build theme fonts from there we can choose any of them. This article will focus on how to change the theme font in Excel. I hope you enjoy the article and gain some valuable knowledge.
When it comes to dealing with theme font, Excel gives us numerous options through which we can change our theme font. But we can also customize the theme font by changing the heading font and body font together.
1. Changing Theme Font by Using Built-in Fonts in Excel
We can change the in-build font. By default, the office will give you Calibri font. You can change it to a different font. We take a dataset that includes some donor IDs, types, and amounts
To change the build-in theme font, you need to follow the following steps carefully.
- First, go to the Page Layout in the ribbon.
- Next, select the Fonts option from the Themes group.
- In the Font option, we have found several Font options.
- By default, the theme Font is Calibri.
- Now, if you want to change it, you can do it from the list.
- We want to set the theme font Arial.
- Then, we need to select it from the theme Font list.
- When we select the Arial theme Font, we will see our dataset font changing from Calibri to Arial. See the screenshot.
- Now, if you don’t like Calibri and Arial font, you have more options to choose from in the theme Font list.
- You can select Corbel from the theme Font list.
- Corbel Font will give you a new Font appearance compared to the other two. See the screenshot.
- Another popular theme Font we use in our day-to-day life is probably Arial-Times New Roman.
- You can also get the Arial-Times New Roman in the theme Font list.
- It will change your theme Font in a different manner. See the screenshot.
Read More: How to Create an Excel Theme
2. Customizing Excel Theme Fonts to Change Them
We have discussed how to change the build-in theme Font. But we can customize the theme Font. The build-in Font provides the same Heading font and Body font whereas, in the customized theme font, we can set the different fonts in the Heading font and Body Font. We can have a better appearance in the customized theme font. To set the Customize Font, you need to follow the following steps carefully.
- First, go to the Page layout in the ribbon.
- In the Themes group, select Fonts.
- In the Fonts options, select Customize Fonts.
- Create New Theme Fonts dialog box will pop up.
- Here, we can change the Heading font and Body font.
- There is a sample section where you will find the sample after changing fonts.
- We set the Heading font as Calibri.
- Set the Body font as Times New Roman.
- See the Sample after changing the fonts.
- You can change the name of your customized theme fonts.
- Finally, click on Save.
- That will provide you with the following appearance. See the screenshot.
- Now, if you think, you can customize the theme font in a whole different way. Then, again go to the page layout
- From the Themes group, select the Fonts.
- Then, in the Fonts option, select Customize Fonts.
- Now, Change the Heading font and the Body font.
- We take Ariel as the Heading font.
- We set Corbel as the Body font.
- Next, set the Name.
- Finally, click on Save.
- It will provide a different outlook compared to the previous customized theme font.
Read More: How to Apply a Theme to a Workbook in Excel
Download Practice Workbook
We have shown two different ways to change the theme font. In those two ways, you can set several more theme fonts. Here, we have also discussed how to customize your theme font which is very useful in some cases. If you have any questions, feel free to ask in the comment box.
- How to Apply Parallax Theme in Excel
- Change Excel Theme to Black
- How to Apply Retrospect Theme in Excel
- [Solved!] Excel Themes Option Is Not Working
- [Solved!] Excel Feathered Theme Missing
- How to Add Excel Feathered Theme
- How to Apply Slice Theme in Excel
- How to Make Good Excel Color Combinations
- How to Change Theme Colors in Excel