How to Create an Excel Theme (Step by Step Guide)

Get FREE Advanced Excel Exercises with Solutions!

An Excel theme is a certain look of a worksheet combining specific Color Palettes, Fonts, and Effects. Excel has some built-in themes that can be accessed easily. Apart from that, Excel enables us to create custom themes manually. In this article, I will show you how to create an Excel theme step-by-step.


Watch Video – Create an Excel Theme



What Is a Theme in Excel?

A theme is a special look of the worksheets in Excel. Excel themes differ from one another in terms of colors, fonts, and effects.

Excel has some built-in themes. It also offers to make customizable themes. This means you can modify your preferred colors, fonts, and effects to give a look at your own worksheets.


How to Create an Excel Theme: Step by Step Guide

An Excel theme is made of 3 elements mostly. They are,

  • Colors
  • Fonts
  • Effects

Now, I’m going to demonstrate how to select the colors, fonts, and effects to create an Excel theme step-by-step.


Step-1: Selecting Excel Color Palette to Create Theme

To create a custom Excel theme, at first, you have to select a color palette.

For that,

❶ Go to the Page Layout tab.

❷ Click on the Colors drop-down from the Theme group.

Then you will see a lot of built-in color palettes. You can select any of the color palettes from the list.

But if you don’t like any of them, you can create your own color palette.

For that,

❸ Click on Customize Colors commands at the bottom of the drop-down list.

Selecting a Color Palette to Create an Excel Theme

The Create New Theme Colors dialog box will open.

Under the Theme Colors column, you can select your preferred color for Text, Background, Accent, Hyperlink, Followed Hyperlink, etc.

While you pick up a color from the Theme Colors column, you will see a preview in the Sample column.

❹ Insert the name of your created color palette in the Name box.

If you want to reset your color selection, just click on the Reset button.

❺ Finally, click on the Save button to save the color palette.

creating a custom Color Palette to Create an Excel Theme


Step-2: Selecting a Font to Create an Excel Theme

After selecting a color palette, you need to select a font for your Theme.

To select Fonts,

❶ Go to the Page Layout tab.

❷ Click on the Fonts drop-down.

A drop-down list of fonts will appear.

From the list, you choose any font for your Excel theme. But if you don’t like any font from there,

❸ Click on the Customize Fonts command.

Selecting a Theme Font to Create an Excel Theme

The Create New Theme Fonts dialog box will pop up.

  • You can choose your preferred Heading font.
  • Then choose A Body font.

To save your font selection with a name, insert a name in the Name box.

❹ To save your font selection, click on the Save button.

selecting a custom Theme Font to Create an Excel Theme

Read More: How to Change Theme Font in Excel


Step-3: Selecting a Theme Effect

After selecting the colors and fonts for the Excel theme, you have to select an effect. Effects are basically different styles of the shares in Excel.

To select an effect,

❶ Go to the Page Layout tab.

❷ Then click on the Effects drop-down.

After that, you will see a list of different effects to apply.

For this instance, I’m selecting the Glow Edge effect.

Selecting a Theme Effect to Create an Excel Theme


Step-4: Saving Custom-Made Theme

After choosing the colors, fonts, and effects, you need to save your custom-made theme.

To save,

❶ Go to the Page Layout tab.

❷ Click on the Themes drop-down.

❸ Select Save Current Theme.

Saving a Custom Made Excel Theme

The Save Current Theme dialog box will pop up.

❹ Now give the name of your custom-made theme in the File Name box.

❺ Then click on the Save button.

Your theme will be saved in your specified path.


Apply Custom-Made Excel Theme

If you want to apply your custom made theme,

❶ Go to the Page Layout tab.

❷ Click on the Themes drop-down.

❸ Select Browse for Themes.

❹ Navigate to the folder where you’ve saved your Excel themes.

❺ Click on the Theme to select.

❻ Then click Open.

Now, your custom-made theme will be applied to your Excel sheets.

The following screenshot shows my worksheet before applying the custom-made theme.

The look of my worksheet changes after applying the created Excel theme.

Apply a Custom Made Excel Theme


Download Excel Theme

You can download the Excel theme for your personal use.


Conclusion

To sum up, we have discussed how to create an Excel theme step-by-step. Don’t hesitate to ask any questions in the comment section below. We will try to respond to all the relevant queries asap.


Related Articles


<< Go Back to Excel Theme | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Tags:

Mrinmoy Roy
Mrinmoy Roy

Mrinmoy Roy, a dedicated professional with a BSc in Electronics and Communication Engineering from Khulna University of Engineering & Technology, Bangladesh, brings over two years of expertise to the ExcelDemy project. As a prolific contributor, he has authored around 180 articles, showcasing his deep knowledge and passion for Microsoft Excel, Data Analysis, and VBA. His unwavering commitment to continuous learning, combined with versatile skills, renders him well-suited for roles in data management and spreadsheet solutions. He has interest... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo