Lutfor Rahman Shimanto
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.
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.
- 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.
- 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.
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.
- 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.
- As a result, it will ultimately provide the intended effect.
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.
- 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.
- 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.
- 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.
- Consequently, it will finally have the desired impact.
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.
- 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.
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.
