How to Change Font Style in Excel (5 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

Overview of Change Font Style

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:

  1. Select a cell or a range of cells.
  2. Go to the Home tab > Font group.
    Opening Font Group
  3. Change the font name, size, or color.
  4. Make the font bold and italic.
    Options to change Font Style

Thus, you can change the font style in Excel.

Output of Changing Font Style with Font Group

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:

  1. Select a range of cells.
  2. Go to the Home tab > Font group > Font Settings dialog box launcher.
    Opening Font Setting Icon
  3. 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.

    Changing Font Style

Finally, you have the applied font style in the selected cells.

Output of Font Setting Icon

Read More: [Fixed!] Excel Default Font Is Not Changing

Using VBA

You can change the font style in Excel using VBA. Follow the steps:

  1. Select a cell or a range of cells.
  2. Go to the Developer tab > Code group > Visual Basic to open Visual Basic Editor.
    Opening Visual Basic Editor
  3. Go to the Insert tab > Module.
    Opening Module
  4. 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
  5. Click Run or press F5.
    Running the VBA

Finally, you have the font style according to the VBA code.

Output after VBA

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:

  1. Go to the Page Layout tab > Themes group > Fonts.
  2. Pick a font for the blank cells.
    Setting Font from Theme Font

Now, you will have all the newly inserted data in the defined font.

Output after Changing font from Theme Fonts

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:

  1. Go to the Home tab > Styles group > Cell Styles.
  2. Now, right-click on Heading 2 and select Modify.
    Modifying Cell StylesA Style dialog box will appear.
  3. Check only the Font box and click on Format.
    Setting Command in Style BoxA Format Cells dialog box will pop up.
  4. Define font styles from the Format Cells dialog box.
    Setting Font Style
  5. Click OK again from the Style box.
    Confirming Font Style
  6. Now, select a range of cells and apply the modified cell style.
    Applying Modified Cell Style

Thus, you can change the font style with just one click.

Output of Applied Cell Style

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:

  1. To increase the font size: Alt + H, FG.
  2. To decrease the font size: Alt + H, F, K.

Related Articles

<< Go Back to Excel Fonts | Excel Cell Format | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Lutfor Rahman Shimanto
Lutfor Rahman Shimanto

Lutfor Rahman Shimanto, BSc, Information Technology, Jahangirnagar University, Bangladesh, has worked with the ExcelDemy project for over a year. He has written 50+ articles and provided solutions of 100+ comments for ExcelDemy. Currently, he works as an Excel & VBA Developer and provides support and solutions in the ExcelDemy Forum. He has solved 100+ ExcelDemy Forum problems. His work and learning interests are in developing various Excel & VBA and Desktop applications. Outside of work, he enjoys Chess... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo