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.
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:
- 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.
- 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.
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:
- 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.
- You will figure out that the font style of the data is converted from default to Arial.
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:
- At first, select the entire worksheet.
- Now, right-click on your mouse and select the Format Cells option from the Context Menu.
- 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.
- You will notice that the font style not changing issue is solved.
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:
- 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.
- As a result, a dialog box will appear.
- Now, in the Insert tab on that box, click the Module option.
- 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.
- 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.
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)
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.
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!