How to Change Default Font in Existing Excel Workbook

Get FREE Advanced Excel Exercises with Solutions!

The 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.

In the Excel tutorial, you will learn how to change the default font in an existing workbook.

In the following dataset, we have information about a company in a default Calibri font. We will try to change the default font in the existing Excel workbook.

Overview of Changing Default Font

3 Ways to Change Default Font in Existing Excel Workbook

To change the default font in the existing Excel workbook, you can use the Theme Fonts option from the Page Layout tab, Cell Styles from the Home tab, or a VBA code.

Here are the 3 ways to change the default font in the existing Excel workbook:

Using Theme Fonts Option from Page Layout Tab

The Theme Font feature changes the default font of all sheets in the existing Excel workbook. There is no need to select the sheets separately.

To change the font for all sheets in the existing Excel workbook with the Theme Font option:

  1. Select any cell.
  2. Go to the Page Layout tab > Themes group > Fonts.
  3. Pick a font from the available fonts.
    Changing Default Font from Page Layout Tab

You get the output after changing the default font in the existing Excel workbook.

Output after Changing Default Font from Page Layout Tab

Read More: How to Increase Font Size Using Keyboard in Excel

Using Cell Styles Option

You can use the Cell Styles option from the Home tab to change the default font in the existing Excel workbook. You must select the existing worksheets and all cells in a worksheet before using Cell Styles. The applied font will be the default one for any new worksheets you create.

To change the default font in the existing Excel workbook using Cell Styles:

  1. Move your cursor to the sheet name tab.
  2. Right-click on the mouse.
  3. Select the Select All Sheets option.
    Selecting All Sheets
  4. Next, select any cell on the sheet.
  5. Press Ctrl + A to select all cells.
  6. Now, select Cell Styles from the Home tab.
  7. From the drop-down, right-click on the mouse keeping the cursor on Normal.
  8. Select the Modify option.
    Selecting the Modify OptionYou can notice from the Style dialog box that the present default font is Arial 11.
  9. Check only the Font box and click on Format.
    Selecting the Format Option
  10. From the Format Cells dialog box:
    • Go to Font tab > Font.
    • Select a font and click OK.

  11. Click OK again from the Style box.
    Confirming from the Style box

You will have the applied font as the default for the existing Excel workbook.

Output after changing Default Font

Read More: How to Change Font in Excel for All Sheets

Using Excel VBA

You can easily change the default font of the existing workbook using VBA in Excel. The code is only applicable to the worksheets that already exist in the workbook. It does not work for any worksheets that will be created after running the code.

Follow the steps to change the default font in the existing Excel workbook with VBA:

  1. Go to the Developer tab > Visual Basic to open Visual Basic Editor.
    Opening Visual Basic Editor
  2. Go to the Insert tab > Module.
    Opening Module
  3. Copy and paste the following VBA code:
    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.
  4. Click on Run.
    Running the VBA Code

Thus, you can change the default font in the existing Excel workbook with VBA.

Output After Changing Font with VBA

Note: If you don’t see the Developer tab in the ribbon, you have to enable the Developer tab from Excel Options.

How to Change Default Font in Excel Workbook

To change the default font in the Excel workbook, you can use the Excel Options. Keep in mind that changing the default font from the Excel Options will not apply to the current workbook at all. Rather it will be applicable for all newer workbooks.

Follow the steps to change the default font for Excel workbooks using Excel Options:

  1. Select the File tab.
    Selecting File Tab
  2. Go to Options.
    Going to Options
  3. From the Excel Options dialog box:
    • Go to the General tab > When creating new workbooks group > Use this as default font.
    • Pick a font from the drop-down and click OK.

     Selecting a Default Font

  4. Click OK in the confirmation message box.
    Confirmation AlertThis doesn’t change the font in a workbook that already exists.
  5. Close Excel and create a new blank workbook to see the changed default font.
    Go to the File tab > Home > Blank workbook.
    Generating New Workbook

You will find the changed default font in the new workbook.

Final Output After Changing Default Font

Download Practice Workbook

To practice by yourself, download the following workbook.

Conclusion

In this article, we’ve explored 3 easy methods to change the default font in your existing Excel workbook. You can do this by utilizing the Font option from the Page Layout tab, the Cell Styles option from the Home tab, or by using a VBA code. Additionally, we’ve covered how to set a new default font for your entire workbook in Excel. If you have any questions or opinions, feel free to share them in the comments section below. Your feedback is valuable!

Frequently Asked Questions

How do I change the font in Excel workbook?

To change the font in the Excel workbook, select all the existing sheets in the workbook from the Sheet Tab. Then select cells from those worksheets by pressing Ctrl+A from the keyboard. Now change the font from the Font option under the Home tab or from the Context Menu.

How do I change the default font color in Excel workbook?

To change the default font color in the Excel workbook, select all the sheets > press Ctrl+A to select all the cells > go to the Home tab > Font group > Font Color.

Will changing the default font affect the existing data in the Excel workbook?

Absolutely not; changing the default font only modifies the visual appearance. It does not modify the existing data.

Related Articles

<< Go Back to Excel Fonts | Excel Cell Format | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Sudipta Chandra Sarker
Sudipta Chandra Sarker

Sudipta Chandra Sarker, BSc, Electrical and Electronic Engineering, Bangladesh University of Engineering and Technology, Bangladesh, has worked on the ExcelDemy project for over a year. For ExcelDemy, he has authored 42 articles and reviewed over ten articles. He is employed as a junior software developer at the moment. He aims to create various useful Microsoft Office Add-ins, extending the functionality of Office programs. His interests span Microsoft Office Suites, Data Science, VBA, VB.NET, ASP.NET, C#, Excel, and Desktop... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo