If you want to set the default font and font size in Excel using Registry Editor and Local Group Policy Editor, you need these guides to get it done. If you are unable to change those settings using UI options, you can always follow the REGEDIT and GPEDIT methods, as mentioned here.
How to set the default font in Excel using Registry
To set the default font in Excel using Registry, follow these steps:
- Press Win+R to open the Run dialog.
- Type regedit and press the Enter button.
- Click on the Yes button.
- Navigate to office16.0 in HKCU.
- Right-click on 16.0 > New > Key and name it as excel.
- Right-click on excel > New > Key and set the name as options.
- Right-click on options > New > String Value.
- Name it as font.
- Double-click on it to set the Value data as font name and size.
- Click the OK button.
- Restart your computer.
Let’s learn more about these steps in detail.
To get started, press Win+R to open the Run dialog, type regedit, and press the Enter button. If the UAC prompt appears, click on the Yes button to open the Registry Editor on your computer.
After that, navigate to the following path:
HKEY_CURRENT_USERSoftwarePoliciesMicrosoftoffice16.0
Right-click on 16.0 > New > Key and name it as excel. Then, repeat these steps to create a key named options under excel.
Once done, right-click on options > New > String Value and set the name as font.
Next, you need to double-click on the font String Value to set the Value data in this format:
Font-name, font-size
Let’s assume that you want to set Arial at 10px. If so, you need to enter the Value data like this: Arial, 10.
Finally, click the OK button and restart your computer to apply the change.
How to change default font in Excel using Group Policy
To change the default font in Excel using Group Policy, follow these steps:
- Press Win+R to open the Run prompt.
- Type gpedit.msc and click the OK button.
- Navigate to General in User Configuration.
- Double-click on the Font setting.
- Select the Enabled option.
- Enter the font name and size in the box and click the OK button.
- Restart Excel.
To know more about these steps, continue reading.
First, you need to open the Local Group Policy Editor on your computer. To do that, press Win+R, type gpedit.msc, and click on the OK button.
Next, navigate to the following path:
User Configuration > Administrative Templates > Microsoft Excel 2016 > Excel Options > General
Double-click on the Font setting visible on the right side and select the Enabled option. Then, enter the font name and size in this format: font-name, font-size.
Like the REGEDIT method, you need to enter a font name size like this: Arial, 10.
Finally, click the OK button and restart the Excel app if it was opened while changing the setting.
What is the default font for Office 365?
In most Office apps, Calibri is used as the default font. Not only just the font family, but also it uses the same size (11px) across some apps. However, if you want to change the default font in Word, Excel, or PowerPoint, you can do so via their program settings too. If you want to do the same in Excel using REGEDIT or GPEDIT, you can follow the aforementioned guides.
How do I change the default font in Office 365 online?
It is not possible to change the default font in Office 365 Online. Whether you want to change the default font family or font size in Word Online, Excel Online, PowerPoint Online, or anything else, you cannot change them in those apps. However, the same is possible on desktop apps.