Themes in Excel consist of custom colors, fonts and style options that you select. Often, you may find yourself wanting to use these themes over and over again. Fortunately, there’s an easy way to save them. Let’s learn how to save themes in Microsoft Excel.
How to Save Themes in Excel
Let’s imagine that you have a theme in Excel, and you want to share it with others. Or, you want to use it again and again without making choices like color selections from scratch. There’s a quick way to do this that saves you time and hard work.
To save themes in Excel, begin by going to the Page Layout tab. You’ll find this on Excel’s ribbon, between the Insert and Formulas tabs. Click on it.
Over on the far left side, you’ll see the Themes dropdown. Here, you can select from the default Excel themes, or browse for more designs online. Once you have a theme built, you can then save it in Excel.
Still working in the Themes dropdown, click on Save Current Theme at the bottom. Excel will launch the Save Current Theme menu. Here, you can name your theme file in the Save As box. By default, Excel will store the theme in the Themes folder. When you’re finished, click Save.
From here, you have two options. You can browse to the Themes folder on your computer, then share your custom saved theme with others via email or a file-sharing app like Microsoft OneDrive.
You’ll also find that your custom theme is available for your own use. When you click on the Themes dropdown again, you’ll see that the theme appears in the newly-created Custom section.
Clicking on it will immediately open the theme in Excel, ready to use and customize again and again.
As you can see, it’s easy to save themes in Excel.