Solved

Excel 2010

Posted on 2013-11-21
8
229 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
0
Comment
Question by:Jeremy-M
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 50
ID: 39666813
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
0
 

Author Comment

by:Jeremy-M
ID: 39667327
Please see the image shown below for a better understanding of what I want to do.

Theme Font Image
0
 
LVL 50
ID: 39670859
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
0
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 

Author Comment

by:Jeremy-M
ID: 39688417
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.
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 500 total points
ID: 39689011
Got a bit carried away with the styles thing, did I?

OK, here are the steps to change a Theme Font.

- Page Layout Ribbon > Fonts drop-down > Create New Theme Fonts
- Select the desired fonts for heading and body and give the new set a name
- Ensure that the new font set is selected in the Fonts drop-down

Now the font selection dialog will show these font names as the defaults for heading and body)

If you want to use these settings in other files, click the Themes drop-down on the Page Layout ribbon and save the current theme. You can assign a name to it and it will be saved in your Windows profile. You can use that theme for other Office documents as well.

cheers, teylyn
0
 

Author Comment

by:Jeremy-M
ID: 39691339
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
0
 

Author Closing Comment

by:Jeremy-M
ID: 39691341
Teylyn, got a bit carried away with the "styles thing" otherwise his or her grade would have been an "A"
0
 
LVL 50
ID: 39692080
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
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question