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.

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

How to Change Theme Colors in Excel


Step 1: Customizing Excel Theme Colors Through Page Layout Tab

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


Step 2: Changing 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 Change Theme Font in Excel


Step 3: Saving the New Theme Color in Excel

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


Download Practice Workbook

Download the following practice workbook for self-exercise.


Conclusion

In this tutorial, I have discussed a simple way to change theme color in Excel. I hope you found this article helpful. Please, drop comments, suggestions, or queries if you have any in the comment section below.


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:

Hafizul Islam
Hafizul Islam

Hafizul Islam is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo