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