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.
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.
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.
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!
Download Practice Workbook
Download the following practice workbook for self-exercise.
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.
- How to Change Excel Theme to Black
- How to Make Good Excel Color Combinations
- How to Create an Excel Theme
- Excel Themes Option Is Not Working
- Excel Feathered Theme Missing
- How to Add Excel Feathered Theme
- How to Apply Parallax Theme in Excel
- How to Apply Retrospect Theme in Excel
- How to Apply Slice Theme in Excel
- How to Apply a Theme to a Workbook in Excel