In Excel, Microsoft uses Calibri as the default font and 11px size. However, if you want to change the default font in Excel, you can use program settings. For some reason, if you need an alternate method, you can use REGEDIT or GPEDIT.
Why should I Change the Default Font in Excel?
There may be several reasons you might want to change the default font in the MS Office Excel program, such as you might be bored with the same old font. Using a new default font may be just what you need to revive your motivation. Also, many companies have their own fonts that they use as part of their branding strategy.
Whatever the reason may be, changing the default font in Excel is very easy, and you just need to do it once. The new default font is applied when you create a new blank worksheet or workbook.
In this gearupwindows article, we will guide you on setting the default font for the Excel program. We will use the Excel settings to change the font. We will also show you through configuring the same using Registry Editor and Local Group Policy Editor if you are using Windows 11 or 10.
How to Set Default Font in Excel using Program Settings?
To set the default font in Excel using its settings, do the following:-
Step 1. Open a new Excel Worksheet.
Step 2. Then, click on
Step 3. After that, click
Step 4. When you’re done, the Excel Options window will appear on your computer. Select
Step 5. Next, click
That’s it. The new default font is applied when you create a new blank worksheet or workbook.
How to Set the Default Font in Excel using Registry Editor?
To set the default font in Excel using Windows 11 or 10 Registry Editor, do the following:-
Step 1. First, open the Registry Editor.
Step 2. Then, navigate to the following path on the left side of Registry Editor:-
Step 3. Next, right-click on the
Step 4. Name the newly created key as
Step 5. Now, right-click the
Step 6. Next, right-click on
Step 7. Name the newly created REG_String as
Step 8. After that, double-click on the
For example, to set Arial at 12px, you need to enter the Value data as
Step 9. Click
Step 10. Finally, restart your computer to apply the change.
How to Change Default Font in Excel using Group Policy Editor?
If your Windows 11 or 10 PC supports Local Group Policy Editor, use the following steps to set or change the default font in Excel:-
Step 1. Open Local Group Policy Editor.
Step 2. When the Local Group Policy Editor appears on your computer, navigate to the following path:-
User Configuration > Administrative Templates > Microsoft Excel 2016 > Excel Options > General
Step 3. Then, double-click on the
Step 4. Next, enter the font name and size in the following format:-
Step 5. Click
Step 6. Click
Step 7. Finally, restart your computer to apply the changes.