It is easy to create a custom theme in Excel 2007. This theme might contain custom colors, fonts, and effects. Episode 531 shows you how to define a theme and share it with others.
This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every workday to learn one of the tips from the book!
This blog is the video netcast companion to the new book, Excel 2007 Miracles Made Easy. Download a new two minute video every workday to learn one of the tips from the book!
Transcript of the video:
Hey welcome back to the MrExcel netcast, I'm Bill Jelen.
Well, last week we were talking about how to customize the colors in Excel 2003, just to finish this up let's talk about that in Excel 2007.
Basically what you're going to do in Excel 2007 is create your own custom Theme, and you have to choose one of the built-in effects, so we'll just choose effects from one of the existing themes and then a theme is comprised of two different fonts.
If you go to the page Layout, tab the fonts and then create new theme fonts, you have to choose a heading font and a body font.
So you can choose what you like for the heading and the body, click SAVE and then you have to go into colors.
Now a theme is comprised of basically six different accent colors and two text colors, two background colors.
So you have to go through and define your various colors, basically you're not limited to 256 colors or anything like that, you can choose any RGB value that you want in the 16 million colors.
See, you can choose the various colors, go through into final six accent colors plus your text colors and the background colors, click SAVE.
Once you've defined all of that, you'll then want to go to the themes drop down and say SAVE CURRENT THEME.
I'll call this podcast, click OK and that creates a THMX file.
Now this is saved in the document themes folder which is located under documents and settings your user ID application data Microsoft templates, and basically you could copy the THMX file from this folder and move it to the same folder on multiple computers, so it would be possible to set up a company-wide theme with your company colors and logo and distribute that to everyone in the company.
Much easier to create a custom theme in Excel 2007 then it was in Office 2003 and try to get that and using all of the different documents on your computer.
Well, hey thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
Well, last week we were talking about how to customize the colors in Excel 2003, just to finish this up let's talk about that in Excel 2007.
Basically what you're going to do in Excel 2007 is create your own custom Theme, and you have to choose one of the built-in effects, so we'll just choose effects from one of the existing themes and then a theme is comprised of two different fonts.
If you go to the page Layout, tab the fonts and then create new theme fonts, you have to choose a heading font and a body font.
So you can choose what you like for the heading and the body, click SAVE and then you have to go into colors.
Now a theme is comprised of basically six different accent colors and two text colors, two background colors.
So you have to go through and define your various colors, basically you're not limited to 256 colors or anything like that, you can choose any RGB value that you want in the 16 million colors.
See, you can choose the various colors, go through into final six accent colors plus your text colors and the background colors, click SAVE.
Once you've defined all of that, you'll then want to go to the themes drop down and say SAVE CURRENT THEME.
I'll call this podcast, click OK and that creates a THMX file.
Now this is saved in the document themes folder which is located under documents and settings your user ID application data Microsoft templates, and basically you could copy the THMX file from this folder and move it to the same folder on multiple computers, so it would be possible to set up a company-wide theme with your company colors and logo and distribute that to everyone in the company.
Much easier to create a custom theme in Excel 2007 then it was in Office 2003 and try to get that and using all of the different documents on your computer.
Well, hey thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
