Manage Office Themes

Understand Office themes

  • Besides using Cell Style to keep the formatting in the worksheet or workbook consistent, you have a choice when you want enhance the appearance of you worksheet or workbook quickly by applying themes. Office themes give your document a designer-quality look in terms coordinating colors and fonts. You can use and share themes among the Office for Mac applications that support themes, such as Word, Excel, PowerPoint.
  • A theme’s colors are divided into two categories:
  • Standard Colors don’t change whether or not you change the theme
  • Theme Colors will change if you change the theme

Apply a theme to a worksheet

1.   Open an existing Excel worksheet or create a new worksheet

2.   From the Ribbon, click Home tab > Themes > click Themes button > select a desired theme in the Theme Gallery to apply to the worksheet

NOTE    The default theme applied to all the documents is called Office



Change different set of colors in a theme

Themes use different colors for elements in a workbook such as: color fills in tables, charts, shapes, or lines. However, each set of theme colors ensures that colors of these different elements in the document coordinate with each other and contribute to a unified look. To change different sets of colors for workbook applied a theme, do the following:

1.   Open a worksheet you want to change the set of theme colors

2.   From the Ribbon, click Home tab go to Themes group, click Colors button and then select a desired color set to apply



Change the fonts throughout a workbook

If you want to change the fonts throughout a document, there is an easier way than selecting all the text and change the font. You can change the fonts for all headings and body in one step

1.   Open a worksheet you want to change fonts

2.   From the Ribbon, click Home tab go to Themes gorup, click Fonts button and then select a desired font palette that you want


 

Create and save a custom theme

1.   Apply changes in colors, fonts and effects in a worksheet

2.   From the Ribbon, click Home tab go to Themes group, click Themes button and choose Save Theme…

In the Save Current Theme dialog box, do the following:

1.   Change the name of the current theme in Saveas box
2.   Make sure save a custom theme in My Themes folder


3.   Click Save button

4.   The custom theme will display in the Themes Gallery



 

Change from the current theme to another theme

1.   Open an worksheet you want to change to different theme

2.   From the Ribbon, click Home tab and go to Themes group click Themes button and select a different theme in the Theme Gallery to apply to the worksheet



Remove a theme

In Excel, all workbooks must contain a theme. Therefore, you cannot actually remove a theme, but you can apply a different theme. If you want to display very little or no color in your document (a plain look), apply the default theme

1.   Open an worksheet you want to change to the default theme

2.   From the Ribbon, click Home tab and go to Themes group, click Themes button and choose Office