Set your default Excel theme to the theme of your choice.

How to Set up a Default Theme in Excel

When you create a new Excel workbook, you'll notice that information technology e'er reverts to the Office theme color past default.

Nevertheless, in some cases, you might have a ready of divers theme colors that you want to use every fourth dimension you create a new workbook.

Instead of changing the colors of all the elements in the workbook i by 1, Excel allows you lot to store a custom theme that yous can apply with a few clicks.

Unfortunately, different Microsoft Word, Microsoft Excel does non have an option to set a custom theme as the default theme.

Luckily, there is a workaround to practice this on Microsoft Excel. To do this, salve an empty Excel sheet containing the desired theme colors equally an Excel template inside the Excel Showtime folder.

excel change default theme color report dashboard

Defining  a custom theme

A theme is a combination of colors, fonts and effects.

This is especially pregnant when you need to create charts and you want them to look compatible using a certain color palette  for the lines and bars .

Each newly-created chart applies the Part  theme past default, and so, p re-defining the colors of Series i, Series 2, then on, and then saving it as a theme will save you the time of having to modify them every time you add a new chart.

To ascertain a new custom theme:

  1. Go to thePage Layout tab.
  2. SelectColors in the Themes section.
  3. SelectCustomize Colors.

iv. In the window popup, c hange the colors according to your preferred palette.

five. Rename the theme.

6. ClickSave.

As an instance, I renamed the theme equally "LG Default one". You will find the new custom theme underPage Layout >Colors. Apart from defining colors, the fonts and effects tin can be defined as well.

One time you accept finalized the tweaks for all iii components, you tin salve it as a theme. To do this:

  1. Go toPage Layout tab.
  2. SelectThemes.
  3. SelectSave Current Theme.

4. Rename the file proper name of the theme.

5. Brand sure that forSave as type, "Part Theme" is selected.

6. Click onSave.

For this example, I take saved it using the filename "Theme LG Default".

Information technology is saved under Certificate Themes under the Templates folder.

Setting the default theme

In one case the custom theme has been created, it can now be prepare equally the default Excel theme.

To practise this:

  1. Open a new blank workbook.
  2. Go to Themes nether thePage Layout tab.
  3. Select the custom theme you want to fix as default. This is the only change that is made to this workbook. Make sure to proceed the workbook bare.

iv. Become toFile and selectSalve As.

5. Keep the file proper name as is merely delete the number at the finish (eastward.g. "Book" instead of "Volume one").

half-dozen. Nether theSave A s type dropdown, selectExcel Template.

seven. Save it directly in the XLSTART binder, which yous will demand to locate manually. If yous are unable to locate information technology in the Save window, save information technology in the Desktop in the concurrently and locate the folder using the Explorer.

eight. ClickSave.

nine. Shut Microsoft Excel.

Finding the XLSTART folder

If yous are unable to locate the Excel Start folder:

  1. Open up the Explorer
  2. Type XLSTART in the search box.
  3. Once it is constitute, get to the Desktop.
  4. Right click on the template you have saved. Select Cut. Another style to do this is to press CTRL + Ten.
  5. Go to the XLSTART binder. Do a right click and select Paste, or press CTRL + V.

Testing the default template

To know if the new theme has been successfully fix equally the default theme, create a new Excel workbook.

Go to Page Layout > Themes.

Information technology should show that your custom theme is currently in utilise.

Video

Excel Dashboards that Inform & Impress

Use these techniques in your own reports

Unbeatable value!