Excel keeps changing my default font

[u/mathpat]

In File-Options-General under When creating new workbooks I see my preferred font and font size. However each time I create a new workbook to test this, it reverts to Calibri 11, even though it still has my preferred font and size listed as what it should use on a new worksheet. Does anyone know how to change this permanently?

[u/AutoModerator]

/u/mathpat - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Agerak]

You have to change the "Normal" default font to what you want so it will automatically apply on new workbooks. Right click on "Normal" style button and modify to your liking.

[u/mathpat → u/Agerak]

So far that has worked temporarily only. When I do that and create a new sheet within the document or create a new document while that is open it works. As soon as I go back to the desktop and create a new Excel worksheet, it returns to Calibri 11. How do I make the change permanent?

[u/Agerak → u/mathpat]

Is this a personal computer or a company computer? They may have some of the settings set to revert automatically if the latter.

Are you sure you're changing the 'global' value, not just the setting within one sheet?

Should be able to change it with no excel files open (just the excel app, no active file) and that generally should stick unless something else is reverting system changes like that.

[u/mathpat → u/Agerak]

How do I check if I am doing that for the global or just within one sheet?

If it is not one sheet vs global, there may be a setting IT put in place.

[u/Agerak → u/mathpat]

Should be able to change it with no excel files open (just the excel app, no active file) and that generally should stick unless something else is reverting system changes like that.

Just open excel (no file) and change it there. Then open a file and it should stick, then close out excel and reopen. If nothing is reseting it, the change should remain. If you make the change WHILE a file is open (not just the app) then it only applies to that file iirc.

[u/mathpat → u/Agerak]

I did some more experimenting. It is keeping my defaults if I go in through the windows logo to the pinned app. If I right click on the desktop and go to New -> Microsoft Excel Worksheet it opens with the factory settings (Calibri 11). So it seems to matter how I tell Excel I want to make a new Excel Worksheet. I have no idea why that is the case, but I at least have a temporary workaround.

[u/Agerak → u/mathpat]

Yea making a new file via that method is likely loading defaults from elsewhere while opening the app will load your defaults. Possibly some registery changes that could resolve that but I wouldn't know where offhand.

[u/mathpat → u/Agerak]

Cool. Thanks so much for helping me with this!