How to☝️ Change the Default Font in Excel

You may have already noticed that the default font in Microsoft Excel is Calibri, font size 11.

Default font in Excel (Calibri)

A lot of people like this font because of its warmth and rounded lines, but it doesn’t mean you’re supposed to use it all the time.

When you have to change the font only once to achieve a specific goal, you can easily do it using the tools in the Font group. 

But what if you need to use a different font in all of the spreadsheets you create? The good news is that there’s a quick-and-dirty way to do that.

In this tutorial, you will learn how to change the default font in Excel.

Why Would I Ever Need To Change My Default Font?

Changing your default font can save you a great deal of time and help avoid the situation when you have different formatting across the same workbook. 

Additionally, there are more possible reasons why you may want to do that:

  • your organization (be it your school, university, or company) may have specific font requirements;
  • there is a need to use a specific font that will make it easier to visualize certain information;
  • you want to add a personal touch to your data;
  • you’re just sick and tired of Calibri.

Without beating around the bush, let’s get started.

How to Set a Default Font (Windows)

For Windows users, changing a default font is as easy as shelling peas.1. Click the File tab.

Click the File tab

2. Click “More…”

3. Select “Options” from the sidebar on the left.

Click "More…" and select "Options"

4. Once there, the Excel Options dialog box should pop up where you need to navigate to the General tab.

5. Select “Times New Roman” from the drop-down menu next to “Use this as the default font” to set it as your new default font.

6. Once you have finished, click “OK” to apply the changes.

7. When you close the dialog box, you will be asked to restart Excel. Click “OK”.

Click "OK" and restart Excel

8. Make sure you’ve saved everything you need and restart the application. The new font will be automatically applied to all of the new workbooks you’re going to create.

Times New Roman as the new default font in Excel

How to Set a Default Font (Mac)

If you’re using a Mac, follow the steps outlined below to change the default font in Excel.

1. Click the Excel menu and choose “Preferences.”

Choose "Preferences" on Mac

2. In the Excel Preferences dialog box that appears, under “Authoring,” select “General.”

Excel Preferences "General" (Mac)

3. Open the drop-down menu next to “Default font” and pick your new default font.

Use Times New Roman as the new default font in Excel (Mac)

4. Once you’re done, you will be asked to restart Excel. Click “OK”.

Click "OK" and restart Excel on Mac

5. If you have no unsaved changes, restart the application. When you create a new workbook, it will use the new default font.

Times New Roman as the new default font in Excel (Mac)

Congratulations! Now you are one step closer to taming Excel.

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X