Maintenance Alert: Saturday, October 21st, 7:00am-6:00pm CT. During this time, the shopping cart and information requests will be unavailable.

Make Your Own Theme in Excel

Do you want to enhance your Excel dashboard, charts or reports with branded colors and elements? Say you are working on a new marketing effort that requires a specific look and feel. These elements include specific color combinations to match your corporate logo and so on. It’s possible that Excel’s built-in document themes are not sufficient to meet your design needs. So what do you do? Create a custom theme!Custom Theme_figure 1

Steps to Customize Document Themes

  1. Apply the theme that most closely matches your needs to your document.
  2. Make your adjustments to color, font and design elements using the tools available on the Ribbon:
    • On the Home tab in the Styles and Cells groups.
    • On the Insert tab in the Text group.
    • On the Page Layout tab in the Themes
      group.
  1. Click the Themes button [A] in the Themes group of the Page Layout tab.
  2. Click the Save Current Theme option [B] at the bottom of dropdown panel to open the Save Current Theme dialog box.
  3. Enter a name for your theme in the File name textbox and click Save.Custom Theme_figure 2
  4. To apply your custom theme to another document, open the Theme dropdown panel again. Your saved theme will appear as an option under the Custom heading.Custom Theme_figure 3Custom Theme_Notes Text

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.


Choose a Seminar and Save $10:

Related Excel® Articles

PRYOR+ 7-DAYS OF FREE TRAINING


Courses in Customer Service, Excel, HR, Leadership, OSHA and more. No credit card. No commitment. Individuals and teams.

Categories