How to Set Default Font in Excel on Windows 11 or 10?

In Windows 10/11, you can customize font size. Many reasons to set the default font like, You want to try something new or create effective documents, etc. Some organizations their have own fonts for branding strategy. When you change the default font in Microsoft excel. The new default font is applied when you create a new blank worksheet or workbook.

There are at least three ways to set the default font in excel, these are as follows:-

  1. using program setting
  2. using the registry editor
  3. using the group policy editor

In this risewindows article, we will review all possible ways one by one.

How to Set Default Font in Excel using Program Settings?

To set the default font in Excel using the settings app, do the following steps:-

Step 1. Firstly, Open a new Excel Worksheet.

Step 2. Now, click on File.

Microsoft-Excel-Worksheet-File-menu-1024x815

Step 3. Then, click Options.

Excel-File-Options (1)

Step 4. After that, the Excel Options window will appear on your computer. Select General tab in the left sidebar. Then under the “When creating new workbooks” section, choose the font and its size according to your needs.

Excel-Options-1024x839

Step 5. Then, click OK.

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 steps:-

Step 1. Firstly, open the Registry Editor.

Step 2. Then, navigate to the following path on the left side of Registry Editor:-

HKEY_CURRENT_USER\Software\Policies\Microsoft\office\16.0

Registry-Editor-16.0-1024x728

Step 3. After that, right-click on the 16.0 folder and select New > Key.

New-Key-on-16.0-folder (1)

Step 4. Name the newly created key as excel.

Registry-Editor-excel (1)

Step 5. Next, right-click the excel folder and pick New > Key. Name the newly created key as options.

Registry-Editor-options (1)

Step 6. Then, right-click on options key and choose New > String Value.

New-String-Value-on-Options-1024x728

Step 7. Name the newly created REG_String as font.

Registry-Editor-font-1024x728

Step 8. Now, double-click on the font String Value and set the Value data in the following format:-

font-name, font-size

Set-font-value-1024x728

For example, to set Arial at 12px, you need to enter the Value data as Arial, 12.

Step 9. Then, Click OK.

Step 10. At last, restart your computer to apply the change.

How to Change Default Font in Excel using Group Policy Editor?

To Change the Default Font in Excel using Group Policy Editor, do the following steps:-

Step 1. Firstly, 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

Local-Group-Policy-Editor-General-1024x720

Step 3. Now, double-click on the Font setting on the right side of General and select the Enabled option.

Font-1024x949

Step 4. After that, enter the font name and size in the following format:-

font-name, font-size

Step 5. Click Apply.

Step 6. Click OK.

Step 7. At last,  restart your computer to apply the changes.

That’s it.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: