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!

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.
  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.

PRYOR+ 7-DAY FREE TRIAL


Experience 7-days of unlimited learning, then reap the benefits from a year of training at one low price. No credit card. No commitment. Individuals and teams.


Choose a Seminar and Save $10:

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small> Basics

Microsoft® Excel® Basics

LIVE ONLINE SEMINARS

Jun. 1

Central Time Zone

Jun. 6

Eastern Time Zone

Jun. 7

Central Time Zone

Jun. 9

Pacific Time Zone

Jun. 13

Central Time Zone

Jun. 15

Central Time Zone

Jun. 16

Eastern Time Zone

Jun. 20

Central Time Zone

Jun. 21

Pacific Time Zone

Jun. 23

Eastern Time Zone

Jun. 28

Eastern Time Zone

Jul. 6

Pacific Time Zone

Jul. 7

Central Time Zone

Jul. 11

Eastern Time Zone

Jul. 12

Central Time Zone

Jul. 14

Central Time Zone

Jul. 18

Pacific Time Zone

Jul. 20

Central Time Zone

Jul. 21

Eastern Time Zone

Jul. 25

Eastern Time Zone

Jul. 26

Central Time Zone

Jul. 27

Central Time Zone

Aug. 1

Pacific Time Zone

Aug. 3

Central Time Zone

Aug. 4

Eastern Time Zone

Aug. 9

Central Time Zone

Aug. 11

Central Time Zone

Aug. 15

Eastern Time Zone

Aug. 16

Central Time Zone

Aug. 18

Pacific Time Zone

Aug. 23

Central Time Zone

Aug. 25

Pacific Time Zone

Aug. 29

Eastern Time Zone

Aug. 31

Central Time Zone

Sep. 7

Central Time Zone

Sep. 12

Central Time Zone

Sep. 13

Pacific Time Zone

Sep. 15

Eastern Time Zone

Sep. 19

Central Time Zone

Sep. 21

Central Time Zone

Sep. 22

Eastern Time Zone

Sep. 26

Pacific Time Zone

Sep. 27

Central Time Zone

Sep. 29

Central Time Zone

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>: Beyond the Basics

Microsoft® Excel®: Beyond the Basics

LIVE ONLINE SEMINARS

Jun. 2

Central Time Zone

Jun. 7

Eastern Time Zone

Jun. 8

Central Time Zone

Jun. 10

Pacific Time Zone

Jun. 14

Central Time Zone

Jun. 16

Central Time Zone

Jun. 17

Eastern Time Zone

Jun. 21

Central Time Zone

Jun. 22

Pacific Time Zone

Jun. 24

Eastern Time Zone

Jun. 29

Eastern Time Zone

Jul. 7

Pacific Time Zone

Jul. 8

Central Time Zone

Jul. 12

Eastern Time Zone

Jul. 13

Central Time Zone

Jul. 15

Central Time Zone

Jul. 19

Pacific Time Zone

Jul. 21

Central Time Zone

Jul. 22

Eastern Time Zone

Jul. 26

Eastern Time Zone

Jul. 27

Central Time Zone

Jul. 28

Central Time Zone

Aug. 2

Pacific Time Zone

Aug. 4

Central Time Zone

Aug. 5

Eastern Time Zone

Aug. 10

Central Time Zone

Aug. 12

Central Time Zone

Aug. 16

Eastern Time Zone

Aug. 17

Central Time Zone

Aug. 19

Pacific Time Zone

Aug. 24

Central Time Zone

Aug. 26

Pacific Time Zone

Aug. 30

Eastern Time Zone

Sep. 1

Central Time Zone

Sep. 8

Central Time Zone

Sep. 13

Central Time Zone

Sep. 14

Pacific Time Zone

Sep. 16

Eastern Time Zone

Sep. 20

Central Time Zone

Sep. 22

Central Time Zone

Sep. 23

Eastern Time Zone

Sep. 27

Pacific Time Zone

Sep. 28

Central Time Zone

Sep. 30

Central Time Zone

Advanced Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>-Macros, PivotTables, Charts and More

Advanced Microsoft® Excel®-Macros, PivotTables, Charts and More

LIVE ONLINE SEMINARS

Jun. 3

Central Time Zone

Jun. 8

Eastern Time Zone

Jun. 14

Eastern Time Zone

Jun. 16

Central Time Zone

Jun. 22

Central Time Zone

Jun. 23

Pacific Time Zone

Jun. 27

Eastern Time Zone

Jul. 6

Central Time Zone

Jul. 12

Pacific Time Zone

Jul. 13

Eastern Time Zone

Jul. 18

Central Time Zone

Jul. 19

Eastern Time Zone

Jul. 28

Eastern Time Zone

Jul. 29

Central Time Zone

Aug. 2

Eastern Time Zone

Aug. 9

Pacific Time Zone

Aug. 12

Central Time Zone

Aug. 17

Eastern Time Zone

Aug. 18

Central Time Zone

Aug. 22

Central Time Zone

Aug. 25

Eastern Time Zone

Aug. 31

Pacific Time Zone

Sep. 9

Central Time Zone

Sep. 14

Eastern Time Zone

Sep. 15

Pacific Time Zone

Sep. 19

Central Time Zone

Sep. 27

Eastern Time Zone

Sep. 28

Central Time Zone

Related Excel® Articles

PRYOR+ 7-DAY FREE TRIAL


Experience 7-days of unlimited learning, then reap the benefits from a year of training at one low price. No credit card. No commitment. Individuals and teams.

Categories