We help IT Professionals succeed at work.

Excel 2010

Jeremy-M
Jeremy-M asked
on
248 Views
Last Modified: 2013-12-03
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
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

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

Author

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

Theme Font Image
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

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

Author

Commented:
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.
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

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

Author

Commented:
Teylyn, got a bit carried away with the "styles thing" otherwise his or her grade would have been an "A"
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

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

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.