Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

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
0
Jeremy-M
Asked:
Jeremy-M
  • 4
  • 4
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
Jeremy-MAuthor Commented:
Please see the image shown below for a better understanding of what I want to do.

Theme Font Image
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Jeremy-MAuthor 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.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
Jeremy-MAuthor 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
0
 
Jeremy-MAuthor Commented:
Teylyn, got a bit carried away with the "styles thing" otherwise his or her grade would have been an "A"
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now