How to Change Default Font in Existing Excel Workbook

In this article, we will learn how to change the default font in an existing Excel workbook. Suppose I have a workbook that consists of a dataset. We may wish that when we add something to the dataset and also to the existing workbook, we change the default font. Let’s see 3 easy methods for changing the default font in the existing Excel workbook.


Download Practice Workbook

To practice by yourself, download the following workbook.


What Is Default Font in Excel?

Default font is the font you see when you open Excel. Calibri, Times New Roman, and Arial are popular fonts normally used as defaults. You can also select which font you want to see as the default in Excel.


3 Suitable Ways to Change Default Font in Existing Excel Workbook

In the following dataset, we have information about a company’s Product Id, Product Name, Sales and Revenue. We will show 3 methods using this dataset on how you can change the default font in an existing excel workbook.

how to change default font in existing excel workbook


1. Apply Excel VBA to Change Default Font in Existing Workbook

You can easily change the font of the existing workbook using VBA in Excel. We can easily select the default font here. Here, we will use the dataset below. You can see the font we are using here is Calibri.

Apply Excel VBA to Change Default Font in Existing Workbook

Let’s follow the steps to learn the method.

STEPS:

  • First of all, go to the Developer tab.
  • After that, select Visual Basic to open the Visual Basic window.

  • In the Visual Basic window, you have to select Module from the Insert tab.

  • In the Module window, type the code below.
Sub ChangingDefaultFontInExistingWorkbook()
    For Each iWrksht In Worksheets
        iWrksht.Activate
        ActiveSheet.UsedRange.Select
        Selection.Font.Name = "Arial"
    Next
End Sub

By Selection.Font.Name = “Arial”, we are putting Arial font in our workbook. You can change the font here in which font you want to set as default.
  • Now, we need to save the code first and then, run it.
  • To save the code, simply hit Ctrl + S on the keyboard.
  • After that, press the F5 key to run the code.
  • Otherwise, we can simply click the “run” button shown below after saving.

  • Finally, return to the workbook.
  • Enter any worksheet in the workbook and you can see that its font is changed to Arial.
  • For checking purposes, we have selected our dataset to watch its font and found the desired output.

Apply Excel VBA to Change Default Font in Existing Workbook

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


2. Change Default Font in Existing Workbook Using Home Tab

Using the Home Tab, you can easily change the font of an existing workbook in Excel. Here, we will use the previous dataset.

Change Default Font in Existing Workbook Using Home Tab

Let’s find out the font of the dataset. You can see we have taken the dataset in Calibri font.

Now, let’s follow the steps below to change the default font of the existing workbook in Excel.

STEPS:

  • Firstly, move your cursor on your worksheet in the Sheet Tab and right-click on the mouse.
  • A menu bar will pop up and we have to select the option named Select All Sheets.
  • So, now all my sheets in the existing workbook are selected.

  • Secondly, select any cell of the sheet and press Ctrl + A to select all cells.

Change Default Font in Existing Workbook Using Home Tab

  • Thirdly, go to the Font box and then, select font and font size as per your wish.
  • We want to keep the font Times New Roman and font size 11.
  • So as per our wish, we selected Times New Roman and set the size to 11.

  • Finally, our work is completed.
  • Now, check any worksheet in the workbook and you can see that its font is changed to Times New Roman and font size 11.
  • Here, we have selected our dataset to observe its font and found the desired output.

Change Default Font in Existing Workbook Using Home Tab

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


3. Utilize Cell Styles to Change Default Font in Existing Excel Workbook

Utilizing Cell Styles, you can also easily change the font of an existing workbook in Excel. To explain this method, we will use the following dataset.

Utilize Cell Styles to Change Default Font in Existing Excel Workbook

Let’s observe the steps below to see how we can change the font size in an existing excel workbook.

STEPS:

  • Firstly, select the sheet from the Sheet Tab and right-click on the mouse.
  • A menu will pop up and we have to select the option named Select All Sheets.
  • So, now all the sheets in the existing workbook are selected.

  • Secondly, press Ctrl + A after clicking on any cell of the sheet.
  • So, all the cells of this Excel worksheet are selected.

  • Now, select Cell Styles from the Home tab.

  • After selection, a new window will appear.
  • Now, rightclick on Normal from there.

Utilize Cell Styles to Change Default Font in Existing Excel Workbook

  • Another menu will pop up.
  • You have to select Apply to apply the Normal cell type in all selected cells.

  • Instantly, you will see that all cells are converted into Normal type.
  • Now, by modifying the properties of the Normal type, you can easily change the font and font size.

Utilize Cell Styles to Change Default Font in Existing Excel Workbook

  • Again, go to Normal from Cell Styles and right-click on the mouse.
  • From the menu, select Modify.

  • After that, from the Style dialog box, click Format to select font and font size.
  • Before exiting from the Style box, you can notice that the present default font is Arial 11.

Utilize Cell Styles to Change Default Font in Existing Excel Workbook

  • Now, click on the Font tab in the Format Cells box.
  • A window box will open that contains Font, Font Style, Size etc.
  • Change these parameters as per your wish.
  • We want to keep the Calibri font and size 11.
  • So, from Font select Calibri and keep size 11 as it was before.
  • Press OK.

  • Now in the Style box, it is showing that the Font is Calibri 11.
  • Click OK to set these parameters.

Utilize Cell Styles to Change Default Font in Existing Excel Workbook

  • Now, return to the workbook.
  • Go to any worksheet in the workbook and you can see that its font is changed to Calibri.
  • For checking purposes, we have selected our dataset to watch its font and found the desired output.

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


Conclusion

In this article, we have demonstrated how to change the default font in an existing Excel workbook. Furthermore, there is a practice workbook at the beginning of the article. So, go ahead and give it a try. To read similar articles, check out the ExcelDemy website. Lastly, please use the comment section below to post any questions or make any suggestions you might have.


Related Articles

Tags:

Sudipta Chandra Sarker

Sudipta Chandra Sarker

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was in Electrical and Electronic Engineering from Bangladesh University of Engineering and Technology-Bangladesh. I have a great interest in research and development. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo