How to Change Font Style in Excel (6 Easy Methods)

Excel by Microsoft ranks high among the most useful and powerful software available. We can do many computations on any dataset using Excel’s capabilities and functions. 6 interesting approaches to customizing Excel’s font style are discussed here. Therefore, you can Change the Font Style in Excel using one of the methods.


Download Practice Workbook

You must download the sample worksheet we used during the session.


6 Easy Methods to Change Font Style in Excel

Let’s examine a sample dataset for the sake of illustration. For example, the following dataset has two columns labeled University Name and Year of Establishment: Each of the 6 easy methods for changing the font style in Excel will be used. In addition, I have yet to mention that I’ve used Microsoft Excel 365 for this article. However, you can utilize any other edition that provides maximum convenience.

how to change font style in excel


1. Configure Font Style Through Font Group Commands

In most cases, you may find a helpful preset command to alter the font style under Excel by looking in the Font Group Commands. One of the main benefits of Font Group Commands is the time it saves you while making changes to the font’s look. In this example, we will bold the year of Establishment column through Font Group commands. You can also change the font size, type, and other preset commands in the Font Group. It is essential to follow the steps outlined in the following sections to finish the project successfully.

STEPS:

  • First, select the range C5 to C10.
  • Second, click the Home tab, followed by the Font icon.

Configure Font Style Through Font Group Commands

  • Consequently, the Font Group Commands bar will appear.
  • Then, tap B to bold the selected values.
  • Eventually, it will provide the desired outcome, as seen below.

Read More: How to Increase Font Size Using Keyboard in Excel (3 Easy Ways)


2. Use Font Setting Icon to Change Font Style in Excel

Using the Font Settings Icon is another fascinating method for changing the font style in Excel. Using the Font Settings icon, we will Bold and Italic the values of the University Name column. The steps below explain how to alter the font style in Excel by using the font settings icon.

STEPS:

  • First, select the range B5 to B10.
  • Second, go to the Home tab and click the Font Settings icon.

Use Font Setting Icon to Change Font Style in Excel

  • Due to this, the Format Cells window will pop up.
  • Now, choose Bold Italic, and later hit OK.

  • Finally, it will provide the desired result, as demonstrated below.

Output of Font Setting Icon to Change Font Style in Excel

Read More: [Fixed!] Excel Default Font Is Not Changing (4 Quick Solutions)


3. Customize Font Style with Keyboard Shortcut

Using a Keyboard Shortcut, we may change the font style in Excel. Both Ctrl+1 and Ctrl+Shift+F lead to the Format Cell window. In this scenario, we will alter the font of a record and italicize its values. The methods below describe how to change the Font Style in Excel using the Keyboard Shortcut.

STEPS:

  • First, choose the range from B7 to C7.

Customize Font Style with Keyboard Shortcut

  • Second, press Ctrl+1 or Ctrl+Shift+F.
  • Subsequently, the Format Cells window will display.
  • After that, choose Californian FB and Italic.
  • Now, click OK.

Customize Font Style with Keyboard Shortcut

  • As a result, it will ultimately provide the intended effect.

Output of Customize Font Style with Keyboard Shortcut

Read More: How to Change Default Font in Existing Excel Workbook


4. Modify Font under Excel Theme Settings

We can also change the font style from the Theme Setting. Please follow the steps below to change the font style using Excel Theme Settings.

STEPS:

  • Firstly, navigate to Page Layout to get Themes Groups.

Modify Font under Excel Theme Settings

  • Secondly, go to the Font icon.
  • Next, find and click Georgia.

  • As a consequence, it will eventually produce the desired impact.


5. Alter Font Format in Excel by Modifying Cell Style

Cell Style also allows us to adjust the font style in Excel. In this situation, we shall bold and italicize the font of a range. Please follow the following instructions to alter the font style using Cell Style.

STEPS:

  • First, select the range B9 to C10.
  • Second, choose the Home tab, followed by Cell Styles.

Alter Font Format in Excel by Modifying Cell Style

  • Subsequently, a bar labeled Good, Bad, and Neutral will pop up.
  • After that, right-click on Normal.
  • Later, click Modify.

  • Now, the Style window will open, then select Format.

Alter Font Format in Excel by Modifying Cell Style

  • Next, the Format Cells window pops out.
  • At this time, choose the Bold Italic followed by OK.

  • After that, the Style window will open again, then click OK.

  • Necessary, choose Cell Styles.
  • Subsequently, the bar will pop up again, then select Normal.

Alter Font Format in Excel by Modifying Cell Style

  • Consequently, it will finally have the desired impact.

Output of Altering Font Format in Excel by Modifying Cell Style

Read More: How to Change Font in Excel to All Caps (6 Simple Ways)


6. Change Font Style Through Excel VBA

Using Excel VBA will be the last approach discussed here. Excel VBA allows us to alter the font style across the whole worksheet. Please follow the following procedures to change the font style using Excel VBA.

STEPS:

  • First, navigate to Developer, followed by Visual Basic.

Change Font Style Through Excel VBA

  • Secondly, go to Insert, and later click Module to get the Module Box.

  • Third, input the code below into the Module Box.
Sub ChngFnt()
For Each Worksheet In Worksheets
Worksheet.Activate
ActiveSheet.UsedRange.Select
Selection.Font.Name = "Arial Black"
Next
End Sub
  • Later, click Run or press F5.

  • As a result, It will provide the intended outcome, as seen below.Output of Changing Font Style Through Excel VBA

Conclusion

From now on, you can use the methods we covered to Change Font Style in Excel. You may find a lot more content similar to this on ExcelDemy. Keep using them, and provide any further suggestions for completing the task at hand. Use the box below for any questions, feedback, or ideas.


Related Articles

Tags:

Lutfor Rahman Shimanto

Lutfor Rahman Shimanto

Hi there! I am Lutfor Rahman Shimanto. I have completed my graduation in Information Technology from Jahangirnagar University. Currently, I am working as a technical content writer at ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of work, I enjoy Chess a lot. I am a founding member of the Jahangirnagar University Chess Club and an internationally rated chess player.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo