Avatar of Jeremy-M
Jeremy-M asked on

Excel 2010

How can I change the default theme fronts in Excel from Cambria (Headings) and Calibri (Body) to the fonts that I want to use?

Thanks,

Jeremy
Microsoft Excel

Avatar of undefined
Last Comment
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

8/22/2022 - Mon
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

Hello,

in the ribbon, right-click the style you want to change and then select "Modify". Make the changes you want and repeat for all styles you want to change. Then, on the Page Layout ribbon, click the Themes drop-down and save as a new theme. This will include fonts, colours and effects.

cheers, teylyn
ASKER
Jeremy-M

Please see the image shown below for a better understanding of what I want to do.

Theme Font Image
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

I cannot reproduce the behavior you describe. When I select a theme that has a different base font, the fonts are applied and listed as the default fonts for body and heading (if applicable).  See screenshot.

shot
On the other hand, I have not found a theme with Comic Sans as the base font in the Excel 2010 styles panel.  Where did you get the theme from? Maybe it has not been defined properly? And, are you sure that the problem is with the theme or maybe with the template?

Maybe the sheet has just had all cells formatted to Comic Sans, but the font was never applied to the styles? Can you create a sample file that shows the behavior you describe and attach it here?

You can change the Body and Headings fonts this way: On the Home ribbon, click the lower right hand corner of the Styles panel to see all styles. Right-click the Heading1 style and select "Modify".

step1
Then click the Format button and change the font for the style.  Do the same for the "normal" style, which controls the "Body" style.

step2
cheers, teylyn
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER
Jeremy-M

If you had read my earlier post you would have learned that changing the font type for a style does not change the default theme fonts.


See my response posted on 2013-11-21.
ASKER CERTIFIED SOLUTION
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Jeremy-M

Thank you very much, that worked.

That did exactly what I wanted to do.

I understand how I can set the theme fonts for the heading and the body by selecting my custom theme for each file that I have created or will create.

Is there a way in which I can make this the default theme for all Excel 2010 files that I create or edit?

Thank you for sticking with this. You get straight A's for persistence as well as 500 points!

Can I make this the default theme for all files that I create or edit?

Thank you again,

Jeremy
ASKER
Jeremy-M

Teylyn, got a bit carried away with the "styles thing" otherwise his or her grade would have been an "A"
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

LOL, I guess I deserve that B. Goes to show how much the mindset can influence what you actually see when reading a question. Been working with styles in Excel a lot recently, and got totally side-tracked by that issue.

Glad I was able to finally provide you with the approach you really needed.

>> Can I make this the default theme for all files that I create or edit?

Yes and no.

Yes for new files.

Yes - A: save the file as a template file, then go File > New > My Templates, select the template to create a new file based on that template

Yes - B: You can save the file as the Book.xlst in the Excel startup folder (where exactly that is depends on your Windows version), and when you open Excel, the new, default workbook will have these properties.

No, (but) for existing files

NO - : Each workbook gets saved with its respective theme. So, if you open an existing workbook, it will open with the theme that was applied to it when it was last saved.  You CAN, however change the theme of the opened file, and set it to a theme that you can access from your current machine. That theme will then "stick" to the file until someone else changes it.

cheers, teylyn