How to Change Theme Colors in Excel (with Quick Steps)

Get FREE Advanced Excel Exercises with Solutions!

When you make a new Excel spreadsheet, you notice that it is usually in the MS office theme color with a built-in theme color. However, there are a few techniques in MS Excel to change theme color in your own style. In this article, you will learn a simple way to change theme colors in Excel.

Download Practice Workbook

Download the following practice workbook for self-exercise.

Steps to Change Theme Colors in Excel

Using the following dataset, we will show how to change theme colors in Excel.

How to Change Theme Colors in Excel

Step 1: Go to Page Layout Tab to Customize Theme Colors

First, you need to open the workbook. Then, under the Page Layout tab, click on the Colors. After that click on Customize Colors. A Creat New Theme Colors window will pop up.

How to Change Theme Colors in Excel

Read More: How to Create an Excel Theme (Step by Step Guide)

Step 2: Customize New Theme Color

For each theme color you wish to change, click on the arrow button next to that color. Then, pick a color from the Theme Colors window. In the Name box, enter a name for the new color. And finally, click on Save.

How to Change Theme Colors in Excel

After this, you will see that the theme colors in your data are already changed.

Read More: How to Apply a Theme to a Workbook in Excel (2 Suitable Ways)

Step 3: Save the New Theme Color

In order to save the new theme color, click again Page Layout >> Themes >> Save Current Theme.

Save the theme with a new set of colors with a proper name so that you can easily find it in the list. Now, this changed theme with new colors is permanently there in your Excel app. Use it whenever you need it!

Read More: How to Modify Theme Color, Font, & Effects & Create Custom Excel Theme


In this tutorial, I have discussed a simple way to change theme color in Excel. I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.

Related Articles


Hafiz Islam

Hafiz Islam

Hi there. I am Hafiz, graduated from BUET. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. Now you can see my articles in the ExcelDemy blog.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF