Solved

Excel 2010

Posted on 2013-11-21
8
197 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
  • 4
  • 4
8 Comments
 
LVL 50

Expert Comment

by:teylyn
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

Expert Comment

by:teylyn
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
 

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
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 50

Accepted Solution

by:
teylyn 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

Expert Comment

by:teylyn
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

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

758 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now