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

Microsoft Excel has a default font style and a vast number of different font styles to show the spreadsheet more beautifully to the user. However, sometimes the default font style does not change as per our requirement. In this article, we will demonstrate 4 quick solutions when default font is not changing in Excel. If you are also curious about it, download our practice workbook and follow us.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


4 Possible Solutions When Default Font Is Not Changing in Excel

To demonstrate the solutions, we consider a simple dataset of 10 employees of a company. Their name and income for the first three months of a year are shown in the range of cells B5:E14. Our default font is set in Calibri, and we want to change it to Arial.

Dataset with default font style which is not changing

๐Ÿ“š Note:

All the operations of this article are accomplished by using Microsoft Office 365 application.


Solution 1: Change Default Font from Excel Options

In the first method, we are going to change the default font from the Excel Options option. The steps of this process are given below:

๐Ÿ“Œ Steps:

  • First of all, go to the File > Options option.

  • As a result, a dialog box called Excel Options will appear.
  • Now, in the General tab, from the When creating new workbooks section, click on the drop-down arrow of the Use this as the default font option.
  • Then, choose your desired font style. Here, we choose the Arial font for our workbook.
  • Finally, click OK.

Modify Default Font Which is Not Changing, from Excel Options

  • Excel may show you a message box for restarting the application.
  • Thus, click OK and click on the Close button to close the Excel application.

  • At last, relaunch the application again, and you will notice that the default font style will change.

Change Default Font Style from Excel Options

Hence, we can say that our working procedure works perfectly, and we are able to fix the problem default font not changing in Excel.

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


Solution 2: Modify from Font Group

In this approach, we will change the default font of Excel from the Font group of the Excel ribbon. The procedure is explained below step-by-step:

๐Ÿ“Œ Steps:

  • First, select the entire worksheet.
  • Now, in the Home tab, click on the drop-down arrow of the Font command from the Font group.
  • Then, choose the text font according to your desire. We choose the Arial font for our dataset.

Choosing desired font from the Font command

  • You will figure out that the font style of the data is converted from default to Arial.

Modify Default Font from Font Group Which is not Changing Previously

Thus, we can say that we are able to resolve the issue of Excel default font not changing.

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


Solution 3: Changing from Format Cells Dialog Box

In the following approach, we are going to change the default font from the Format Cells dialog box. The steps of this solution are given as follows:

๐Ÿ“Œ Steps:

  • At first, select the entire worksheet.
  • Now, right-click on your mouse and select the Format Cells option from the Context Menu.

Opening Format Cells dialog box to fix Excel default font style is not changing

  • As a result, a small dialog called Format Cells will appear.
  • After that, in the Font tab, under the Font section, scroll your mouse to find your desired font style and click on the font style. Here, we choose the Arial font.
  • Finally, click OK.

Selecting desire font style to change default font

  • You will notice that the font style not changing issue is solved.

Changing Default Font Style from Format Cells Dialog Box

Therefore, we can say that our solution process works effectively, and we are able to fix this troublesome.

Read More: How to Change Font in Excel for All Sheets (3 Suitable Ways)


Solution 4: Embedding VBA Code

Writing a VBA code can also help you to fix the problem default font not changing in an Excel worksheet. The process is described below step by step:

๐Ÿ“Œ Steps:

  • To start the approach, go to the Developer tab and click on Visual Basic. If you donโ€™t have that, you have to enable the Developer tab. Or You can also press โ€˜Alt+F11โ€™ for opening the Visual Basic Editor.

Launching Visual Basic Edition dialog box

  • As a result, a dialog box will appear.
  • Now, in the Insert tab on that box, click the Module option.

Selecting Module tab

  • Then, write down the following visual code in that empty editor box.

Sub Change_Default_Font()
    For Each Worksheet In Worksheets
        Worksheet.Activate
        ActiveSheet.UsedRange.Select
        Selection.Font.Name = "Arial"
    Next
End Sub
  • After that, press โ€˜Ctrl+Sโ€™ to save the code.
  • Now, close the Editor tab.
  • Afterward, in the Developer tab, click on the Macros option.

Opening Macros box to Run VBA code

  • A new dialog box called Macros will appear. Select the Change_Default_Font option.
  • Finally, click on the Run button to run this code.

  • You will see that the default font style will change.

Embedding VBA Code to Solve Excel Default Font Style Is Not Changing

Finally, we can say that our visual code worked successfully and we are able to fix the issue titled default font is not working in Excel.

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


๐Ÿ“š Note

Besides the approaches mentioned earlier, you can also change the default font theme from the Font drop-down available in the Page Layout tab. For that, go to the Page Layout tab, click on the drop-down arrow of the Font command and choose your desired font theme.


Conclusion

Thatโ€™s the end of this article. I hope that this article will be helpful for you and you will be able to fix the issue when the default font is not changing in Excel. Please share any further queries or recommendations with us in the comments section below if you have any other questions or suggestions.

Donโ€™t forget to check our website, ExcelDemy, for several Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Tags:

Soumik Dutta

Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo