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.

Local Seminars Related to this Topic:

Microsoft® Excel® Basics

LIVE ONLINE SEMINARS

Jul. 26

Pacific Time Zone

Jul. 27

Central Time Zone

Aug. 4

Pacific Time Zone

Aug. 5

Central Time Zone

Aug. 9

Central Time Zone

Aug. 10

Eastern Time Zone

Aug. 11

Central Time Zone

Aug. 17

Eastern Time Zone

Aug. 19

Central Time Zone

Aug. 23

Central Time Zone

Aug. 25

Central Time Zone

Aug. 26

Pacific Time Zone

Aug. 30

Central Time Zone

Aug. 31

Eastern Time Zone

Sep. 8

Central Time Zone

Sep. 13

Central Time Zone

Sep. 14

Pacific Time Zone

Sep. 16

Eastern Time Zone

Sep. 20

Pacific Time Zone

Sep. 21

Central Time Zone

Sep. 22

Eastern Time Zone

Sep. 27

Eastern Time Zone

Sep. 29

Pacific Time Zone

Sep. 30

Central Time Zone

Oct. 4

Eastern Time Zone

Oct. 5

Central Time Zone

Oct. 7

Central Time Zone

Oct. 12

Central Time Zone

Oct. 13

Central Time Zone

Oct. 14

Pacific Time Zone

Oct. 18

Eastern Time Zone

Oct. 19

Central Time Zone

Oct. 21

Central Time Zone

Oct. 25

Pacific Time Zone

Oct. 27

Central Time Zone

Nov. 1

Central Time Zone

Nov. 2

Central Time Zone

Nov. 3

Eastern Time Zone

Nov. 4

Central Time Zone

Nov. 8

Central Time Zone

Nov. 9

Eastern Time Zone

Nov. 15

Pacific Time Zone

Nov. 17

Central Time Zone

Nov. 18

Central Time Zone

Microsoft® Excel®: Beyond the Basics

LIVE ONLINE SEMINARS

Jul. 27

Pacific Time Zone

Jul. 28

Central Time Zone

Aug. 5

Pacific Time Zone

Aug. 6

Central Time Zone

Aug. 10

Central Time Zone

Aug. 11

Eastern Time Zone

Aug. 12

Central Time Zone

Aug. 18

Eastern Time Zone

Aug. 20

Central Time Zone

Aug. 24

Central Time Zone

Aug. 26

Central Time Zone

Aug. 27

Pacific Time Zone

Aug. 31

Central Time Zone

Sep. 1

Central Time Zone

Sep. 9

Central Time Zone

Sep. 14

Central Time Zone

Sep. 15

Pacific Time Zone

Sep. 17

Eastern Time Zone

Sep. 21

Pacific Time Zone

Sep. 22

Central Time Zone

Sep. 23

Eastern Time Zone

Sep. 28

Eastern Time Zone

Sep. 30

Pacific Time Zone

Oct. 1

Central Time Zone

Oct. 5

Eastern Time Zone

Oct. 6

Central Time Zone

Oct. 8

Central Time Zone

Oct. 13

Central Time Zone

Oct. 14

Central Time Zone

Oct. 15

Pacific Time Zone

Oct. 19

Eastern Time Zone

Oct. 20

Central Time Zone

Oct. 22

Central Time Zone

Oct. 26

Pacific Time Zone

Oct. 28

Central Time Zone

Nov. 2

Central Time Zone

Nov. 3

Central Time Zone

Nov. 4

Eastern Time Zone

Nov. 5

Central Time Zone

Nov. 9

Central Time Zone

Nov. 10

Eastern Time Zone

Nov. 16

Pacific Time Zone

Nov. 18

Central Time Zone

Nov. 19

Central Time Zone

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

LIVE ONLINE SEMINARS

Aug. 3

Central Time Zone

Aug. 4

Eastern Time Zone

Aug. 12

Central Time Zone

Aug. 17

Central Time Zone

Aug. 23

Central Time Zone

Sep. 1

Pacific Time Zone

Sep. 9

Eastern Time Zone

Sep. 14

Central Time Zone

Sep. 15

Pacific Time Zone

Sep. 20

Central Time Zone

Oct. 1

Central Time Zone

Oct. 5

Pacific Time Zone

Oct. 6

Central Time Zone

Oct. 12

Central Time Zone

Oct. 21

Central Time Zone

Oct. 25

Eastern Time Zone

Oct. 29

Central Time Zone

Nov. 2

Eastern Time Zone

Nov. 8

Central Time Zone

Nov. 17

Central Time Zone

Nov. 19

Pacific Time Zone

Related Excel® Articles

Leave a Reply

Your email address will not be published. Required fields are marked *