PC & Mobile

How to set default font in Excel using Registry and Group Policy

If you need to set the default font and font dimension in Excel using Registry Editor and Local Group Policy Editor, you want these guides to get it executed. If you might be unable to change these settings using UI choices, you may all the time comply with the REGEDIT and GPEDIT strategies, as talked about right here.

How to set the default font in Excel using Registry

To set the default font in Excel using Registry, comply with these steps:

  1. Press Win+R to open the Run dialog.
  2. Type regedit and press the Enter button.
  3. Click on the Yes button.
  4. Navigate to office16.0 in HKCU.
  5. Right-click on 16.0 > New > Key and identify it as excel.
  6. Right-click on excel > New > Key and set the identify as choices.
  7. Right-click on choices > New > String Value.
  8. Name it as font.
  9. Double-click on it to set the Value knowledge as font identify and dimension.
  10. Click the OK button.
  11. Restart your laptop.

Let’s be taught extra about these steps in element.

To get began, press Win+R to open the Run dialog, sort regedit, and press the Enter button. If the UAC immediate seems, click on on the Yes button to open the Registry Editor in your laptop.

After that, navigate to the next path:

HKEY_CURRENT_USERSoftwarePoliciesMicrosoftoffice16.0

Right-click on 16.0 > New > Key and identify it as excel. Then, repeat these steps to create a key named choices underneath excel.

Once executed, right-click on choices > New > String Value and set the identify as font.

How to set default font in Excel using Registry and Group Policy

Next, you want to double-click on the font String Value to set the Value knowledge in this format:

Font-name, font-size

Let’s assume that you really want to set Arial at 10px. If so, you want to enter the Value knowledge like this: Arial, 10.

How to set default font in Excel using Registry and Group Policy

Finally, click on the OK button and restart your laptop to apply the change.

How to change default font in Excel using Group Policy

To change the default font in Excel using Group Policy, comply with these steps:

  1. Press Win+R to open the Run immediate.
  2. Type gpedit.msc and click on the OK button.
  3. Navigate to General in User Configuration.
  4. Double-click on the Font setting.
  5. Select the Enabled choice.
  6. Enter the font identify and dimension in the field and click on the OK button.
  7. Restart Excel.

To know extra about these steps, proceed studying.

First, you want to open the Local Group Policy Editor in your laptop. To do this, press Win+R, sort gpedit.msc, and click on on the OK button.

Next, navigate to the next path:

User Configuration > Administrative Templates > Microsoft Excel 2016 > Excel Options > General

Double-click on the Font setting seen on the appropriate aspect and choose the Enabled choice. Then, enter the font identify and dimension in this format: font-name, font-size.

How to set default font in Excel using Registry and Group Policy

Like the REGEDIT technique, you want to enter a font identify dimension like this: Arial, 10.

Finally, click on the OK button and restart the Excel app if it was opened whereas altering the setting.

What is the default font for Office 365?

In most Office apps, Calibri is used because the default font. Not solely simply the font household, but in addition it makes use of the identical dimension (11px) throughout some apps. However, if you’d like to change the default font in Word, Excel, or PowerPoint, you are able to do so by way of their program settings too. If you need to do the identical in Excel using REGEDIT or GPEDIT, you may comply with the aforementioned guides.

How do I alter the default font in Office 365 on-line?

It isn’t attainable to change the default font in Office 365 Online. Whether you need to change the default font household or font dimension in Word Online, Excel Online, PowerPoint Online, or the rest, you can not change them in these apps. However, the identical is feasible on desktop apps.

Read:

  • How to change default System Font in Windows 11/10
  • How to set up Custom Fonts on Google Docs

TheWindowsClub Icon

Related Articles

Leave a Reply

Your email address will not be published.

Back to top button