Look Who it Was Random video

Excel - Create Custom Themes in Excel | Easy Step-by-Step Tutorial - Episode 531

753 views · Published 4 August 2009 · 2:32 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Create Custom Themes in Excel.

Welcome back to the MrExcel netcast! In this video, we will be discussing how to create custom themes in Excel 2007. Last week, we talked about customizing colors in Excel 2003, so let's finish up by learning how to do the same in Excel 2007.

To create a custom theme in Excel 2007, you will need to choose one of the built-in effects and then select two different fonts for your theme. This can be done by going to the Page Layout tab, clicking on Fonts, and then selecting "Create New Theme Fonts". From there, you can choose a heading font and a body font that you prefer. Once you have made your selections, click on "Save" to save your custom fonts.

Next, you will need to define the colors for your theme. A theme in Excel 2007 consists of six accent colors, two text colors, and two background colors. You can choose any RGB value for your colors, giving you a wide range of options to create the perfect theme for your project. Once you have defined all of your colors, click on "Save" to save your custom theme.

To make your custom theme easily accessible, you can save it by going to the Themes drop-down menu and selecting "Save Current Theme". This will create a THMX file that can be found in the Document Themes folder, located under Documents and Settings ＞ Your User ID ＞ Application Data ＞ Microsoft ＞ Templates. You can then copy this file and distribute it to multiple computers, making it possible to have a company-wide theme with your company's colors and logo.

Creating a custom theme in Excel 2007 is much easier than it was in Office 2003. This makes it a great tool for businesses to create a cohesive look across all of their documents. Thank you for watching this netcast from MrExcel. Be sure to check out our other videos for more helpful tips and tricks for using Excel. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


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!

Table of Contents:
(00:00) Introduction to customizing colors in Excel 2003 and 2007
(00:26) Creating a custom theme in Excel 2007
(00:38) Choosing heading and body fonts
(00:48) Defining colors for the theme
(01:25) Saving the current theme
(01:42) Location of the saved theme file
(02:04) Easier process in Excel 2007 compared to 2003
(02:14) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Choosing fonts in Excel 2007
Company-wide theme in Excel 2007
Comparing Excel 2007 and Office 2003 theme customization
Copying theme to multiple computers in Excel 2007
Creating custom theme in Excel 2007
Customizing colors in Office 2003
Defining colors in Excel 2007 theme
Document themes folder in Excel 2007
Excel 2007 color customization
Excel 2007 custom theme
Saving current theme in Excel 2007
THMX file in Excel 2007

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152551/

More from this channel