Changing font style in Excel is a process that enhances the visual appeal of the data. It includes changing the font name, size, and color as well as making the font italic or bold.
In this Excel tutorial, you will learn how to change font style.
In the following dataset, we have different university names along with their establishment years. We will change the font styles based on the selection.
Here are 5 easy ways to change font styles in Excel:
Using Font Option
There are a few helpful preset commands in the Font group to change the font style in Excel. The main benefit of the Font group commands is that it is time-saving and easy to operate. You can change the font size, name, and color easily in the Font group.
To change the font style with the Font option:
- Select a cell or a range of cells.
- Go to the Home tab > Font group.
- Change the font name, size, or color.
- Make the font bold and italic.
Thus, you can change the font style in Excel.
Read More: How to Increase Font Size Using Keyboard in Excel
Using Format Cells Dialog Box
To change the font style in Excel, you can use the Format Cells dialog box. You can open the Format Cells dialog box by clicking the Font Settings dialog box launcher or pressing Ctrl+Shift+F.
To change the font style with the Format Cells dialog box:
- Select a range of cells.
- Go to the Home tab > Font group > Font Settings dialog box launcher.
- From the Font tab of the Format Cells dialog box:
- Select a font from Font.
- Pick a style of text from Font Style.
- Click OK.
Finally, you have the applied font style in the selected cells.
Read More: [Fixed!] Excel Default Font Is Not Changing
Using VBA
You can change the font style in Excel using VBA. Follow the steps:
- Select a cell or a range of cells.
- Go to the Developer tab > Code group > Visual Basic to open Visual Basic Editor.
- Go to the Insert tab > Module.
- Copy and paste the following VBA code:
Sub FontChange() With Selection.Font .Name = "Raleway" .Color = RGB(120, 55, 125) .Italic = True .Bold = True .Size = 13 End With End Sub
- Click Run or press F5.
Finally, you have the font style according to the VBA code.
Read More: How to Change Default Font in Existing Excel Workbook
Using Theme Fonts Option
To change font style in Excel, you can use the Theme Font option. This helps to keep a consistent look throughout your whole workbook. Keep in mind that it won’t change the font style for cells with data already. It works best for cells without any information, giving them a specific font style. Follow the steps:
- Go to the Page Layout tab > Themes group > Fonts.
- Pick a font for the blank cells.
Now, you will have all the newly inserted data in the defined font.
Applying Cell Style
Cell Styles option helps you to change font styles easily. Just modify a font pattern in Cell Styles, and then apply it with a single click to change the font style quickly. You can also set a specific number style, alignment, borders, and other features from the Cell Styles option.
To change the font style in Excel with Cell Styles:
- Go to the Home tab > Styles group > Cell Styles.
- Now, right-click on Heading 2 and select Modify.
A Style dialog box will appear. - Check only the Font box and click on Format.
A Format Cells dialog box will pop up. - Define font styles from the Format Cells dialog box.
- Click OK again from the Style box.
- Now, select a range of cells and apply the modified cell style.
Thus, you can change the font style with just one click.
Read More: How to Change Font in Excel to All Caps
Download Practice Workbook
You can download the workbook and practice by yourself.
Conclusion
In this article, we have discussed 5 simple ways to change font style in Excel. To change the font style of selected text directly from the toolbar, use the Font option. Format Cells Dialog Box helps to get access to detailed formatting options, including font styles, in a pop-up dialog box for more specific adjustments. VBA is for advanced users to change font styles, allowing for customized and automated formatting. The Theme Fonts option helps to apply consistent font styles across the entire workbook by choosing from predefined theme fonts. Cell Styles feature changes the font styles with a single click by applying predefined cell styles, providing a quick and consistent way to format cells. If you have any questions or opinions, feel free to share them in the comments section below.
Frequently Asked Questions
How to change the font style for a specific part of the text within a cell?
To change the font style for a specific part of the text within a cell, you need to select the specific part and use the features from the Font group of the Home tab.
Is it possible to use the Theme Fonts option to change the font style of a certain cell?
No, it’s not possible to change the font style of a certain cell with the Theme Fonts option. It changes the font style of all the blank cells of the entire workbook.
What are the shortcut keys to change the font size in Excel?
The shortcut keys to change the font size in Excel are:
- To increase the font size: Alt + H, F, G.
- To decrease the font size: Alt + H, F, K.
Related Articles
- How to Increase Font Size for Printing in Excel
- How to Change Font in Excel for All Sheets
- [Fixed!] Unable to Change Font Color in Excel
- How to Change Font Within Formula in Excel
- How to Lock Font in Excel
- [Solved!] Font Changes Automatically in Excel
<< Go Back to Excel Fonts | Excel Cell Format | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!