How To Create a Theme in Excel

When applying a theme to an Excel 2010 workbook, there may be elements you wish to amend and update.  A theme is a set of colours, fonts and effects that can be adjusted according to your requirements.  Your new updated themes can be saved for future use.

1. Open the workbook that has the theme you wish to modify applied to the contents.

NOTE: If you not have a suitable workbook, open a new, blank workbook and apply a theme to it. To find out more about applying themes, see the How to apply a Theme tutorial.

2. On the Page Layout tab, in the Themes group, select either Colors, Fonts or Effects.  Choose one of the options provided.

NOTE: If none of the sets are suitable for your formatting requirements, you can choose to create a custom set of colours or fonts. To do this, click the relevant option in the Themes group and select Create New Theme Fonts or Create New Theme Colors. Modify according to your requirements and save to create a new set of fonts or colours to choose from.

3. Once you have selected the application Colors, Fonts and Effects, you are ready to save your new theme. On the Page Layout tab, in the Themes group, select Themes.

4. Select Save Current Theme, enter a name for the theme and click Save.

5. To apply the theme to any other workbook, on the Page Layout tab, in the Themes group, select Themes.  All custom themes appear at the beginning of the list.Create and Apply an 

That’s it for creating Themes.  Hope you found it useful – don’t forget to take a look at some of the other tutorials about working in Excel 2010.



If you've any question, problem, suggestion and feedback than please comment below.

Have a nice day!