Set your default Excel theme to the theme of your choice.
How to Set a Default Theme in Excel
When you create a new Excel workbook, you’ll notice that it always reverts to the Office theme color by default.
However, in some cases, you might have a set of defined theme colors that you want to use every time you create a new workbook.
Instead of changing the colors of all the elements in the workbook one by one, Excel allows you to store a custom theme that you can apply with a few clicks.
Unfortunately, unlike Microsoft Word, Microsoft Excel does not have an option to set a custom theme as the default theme.
Luckily, there is a workaround to do this on Microsoft Excel. To do this, save an empty Excel sheet containing the desired theme colors as an Excel template inside the Excel Start folder.
Defining a custom theme
A theme is a combination of colors, fonts and effects.
This is especially significant when you need to create charts and you want them to look uniform using a certain color palette for the lines and bars.
Each newly-created chart applies the Office theme by default, and so, pre-defining the colors of Series 1, Series 2, and so on, and then saving it as a theme will save you the time of having to change them every time you add a new chart.
To define a new custom theme:
- Go to the Page Layout tab.
- Select Colors in the Themes section.
- Select Customize Colors.
4. In the window popup, change the colors according to your preferred palette.
5. Rename the theme.
6. Click Save.
As an example, I renamed the theme as “LG Default 1”. You will find the new custom theme under Page Layout > Colors. Apart from defining colors, the fonts and effects can be defined as well.
Once you have finalized the tweaks for all three components, you can save it as a theme. To do this:
- Go to Page Layout tab.
- Select Themes.
- Select Save Current Theme.
4. Rename the file name of the theme.
5. Make sure that for Save as type, “Office Theme” is selected.
6. Click on Save.
For this example, I have saved it using the filename “Theme LG Default”.
It is saved under Document Themes under the Templates folder.
Setting the default theme
Once the custom theme has been created, it can now be set as the default Excel theme.
To do this:
- Open a new blank workbook.
- Go to Themes under the Page Layout tab.
- Select the custom theme you want to set as default. This is the only change that is made to this workbook. Make sure to keep the workbook blank.
4. Go to File and select Save As.
5. Keep the file name as is but delete the number at the end (e.g. “Book” instead of “Book 1”).
6. Under the Save As type dropdown, select Excel Template.
7. Save it directly in the XLSTART folder, which you will need to locate manually. If you are unable to locate it in the Save window, save it in the Desktop in the meantime and locate the folder using the Explorer.
8. Click Save.
9. Close Microsoft Excel.
Finding the XLSTART folder
If you are unable to locate the Excel Start folder:
- Open the Explorer
- Type XLSTART in the search box.
- Once it is found, go to the Desktop.
- Right click on the template you have saved. Select Cut. Another way to do this is to press CTRL + X.
- Go to the XLSTART folder. Do a right click and select Paste, or press CTRL + V.
Testing the default template
To know if the new theme has been successfully set as the default theme, create a new Excel workbook.
Go to Page Layout > Themes.
It should show that your custom theme is currently in use.
Try it yourself
I hope you liked my tutorial on setting a default theme in Excel. What did you think of it?
Do you have any questions?
In any case, give me an idea of how this worked out by leaving a comment below.
The new Excel Dashboards course is here!
Now available on Udemy
Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.