How To Apply a Theme in Excel

Themes are a combination of colours, fonts and effects that can be applied Excel 2010 workbooks.  You can choose to select from the predefined, built-in themes or you can also change various settings and save it as a new theme.  To find out more about the creating custom themes, see the How to Create a New Theme tutorial.

1. Open the workbook that you would like to apply the theme to.

2. On the Page Layout tab, click Themes in the Themes group to display the various themes 

3. Click the theme you would like to apply to your workbook to see each element alter 

NOTE: The column and row headings also change to reflect the theme.

4. To change any of the Font, Color or Effects, click the relevant category in the Themes group on the Page Layout tab and select an alternative set.
That’s it for applying a Theme.  Hope you found it useful – don’t forget to take a look at our next tutorial on creating a new theme in Excel 2010!



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

Have a nice day!