Your brand is important. There you have it folks. No need to read any more! But seriously, your brand identity is represented in an ever-increasing number of channels and media formats. Printed collaterals, web sites, social media, video content and of course Microsoft Office documents. But how do you make sure your presentations, spreadsheets and documents are kept in line with your brand? Let’s find out.
Introducing the three amigos
The Microsoft 365 offering is all-singing all-dancing but since the dawn of time (…the 1980’s) three Office apps have stood together, arm in arm. Of course, we’re talking about PowerPoint, Excel and Word. Whether you’re creating a presentation, workbook, chart or document, you want the end results to look like they came from the same organisation. You also want to be able to easily copy content from one app to another, copying a chart from Excel and pasting it onto a PowerPoint slide for example, or taking the lovely illustration you created in PowerPoint and dropping it into a Word doc.
However, it can be all too easy to end up with slightly (or very) different versions of your brand across these three apps. Like very, very distant cousins rather than fraternal twins! The best case scenario is that you produce unprofessional looking documents, the worst is that you damage your brand identity in the eyes of potential and current clients.
The key to keeping everything consistent is twofold, starting with an Office theme and ending with templates for each of the Office apps.
What is an Office theme?
A theme tells an Office app how to style a document. It defines the colours, fonts and effects the document will have. Depending on the app themes can control even more, like the masters, layouts and background styles in PowerPoint.
In the example below you can see how one element of a custom theme, the colours, are consistently available across all three apps:
So how do you create and deploy an Office theme?
How to create an Office theme
You can create a theme in any of the Office apps but you can only export it as a theme file, using the thmx format, from PowerPoint. There are other advantages of creating the theme in PowerPoint, such as being able to include important PowerPoint-specific theme features such as background styles, masters and layouts. These are then simply ignored when the theme is deployed in Excel or Word.
1. Set up your colour palette.
In the Design tab, open the dropdown menu in the Variants section and then select Colours > Customize Colours.
Check out this super video for more detail on how to choose and set your theme colours.
You can then copy the colour values from your brand guide into each of the swatches by manually copying the three RGB values for each colour or, in newer versions of PowerPoint, the HTML hex code:
You can also use our free PowerPoint add-in BrightSlide to do this much faster. Edit Theme Colors has a handy colour eyedropper tool so you can pick up the colours from your brand guide directly:
2. Choose theme fonts.
All Office themes have a pair of fonts, one for headings and one for body text. In the Design tab, select Customise Fonts to open the font editor:
Depending on the number and type of Office language packs installed on your computer, you may see multiple sections in this dialog, corresponding to different parts of the world. For example:
3. Avoid Office effects
In the next section of the dropdown menu, you have the option to change the dreaded Office Effects.
Using any but the default Office effect risks taking your content as far away from your brand as it’s possible to go, so we recommend just sticking with the default Office option.
4. Set background style
The final option on this dropdown menu allows you to set the background style. You might want to change the background style if your template has a mix of light and dark background master slides. If it doesn’t, or you’re happy with the default, just leave this selection as is.
How to save an Office theme
Right then that’s your theme set up! The last thing to do is save it as a theme file in the thmx format. Click File > Save As and choose Office Theme:
When you do this, the folder will automatically change to the one used by Office to store its themes which is defined as this alias:
This alias will take you to your personally named folder here:
C:\Users\user name\AppData\Roaming\Microsoft\Templates\Document Themes
Note that there were various places during this process where you could name the elements of the theme, such as the colour and font schemes.
However, there was nowhere you could set the overall name of the theme. If you want to name your theme, you need to change the name of the first slide master in View > Slide Master. Just a classic weird PowerPoint quirk!
Using the theme across Office
You can now choose this theme whenever you create a new document in PowerPoint, Excel or Word. You need to apply it from the right place, which is of course in a different place in each app!
For PowerPoint and Word, it’s in the Design tab. The theme we created above is visible as “My Theme” because we renamed the master:
In Excel themes are in the Page Layout tab:
You can see here that Excel (and Word) uses the name of the thmx file rather than the slide master name that PowerPoint uses.
Okay, so you know how to apply an Office theme – great, but the process is tedious. You don’t want to have to apply the theme every single time you create a new presentation, workbook or document do you?
Setting the default theme in PowerPoint, Excel or Word
Every time you start PowerPoint, Excel or Word, a new presentation, workbook or document is produced. These files are created based on the default templates as specified for each application. The same happens when you create additional new presentations, workbooks or documents using File > New or the shortcut Ctrl+N, which is the same in each app (hurrah for small mercies!). But that’s where the commonality ends because the start-up mechanism is different for each app.
Where are Office themes stored?
Here’s what each app loads as it starts:
|Feature||Default template name||Location|
So, if you want your shiny new theme to be used as the default for your three amigos, you need to save it within the template for the corresponding app.
Let’s take PowerPoint as an example.
- Start PowerPoint and manually apply the theme you created in the Design tab. Add sample slides if you want to.
- Save file as a template. To do this, click File > Save As or Ctrl+Shift+S and then click the Save as type drop to down to locate PowerPoint Template:When you do this, PowerPoint in its infinite wisdom will change the folder to where your personal templates are stored, something like C:\Users\Name\Documents\Custom Office Templates but this is not where the default template is stored!
- To get to the right folder, type %appdata%\Microsoft\Templates in the file name field and then press enter:
- Select the potx file and overwrite it as the new default template (and theme) to open each time PowerPoint starts:
And finally, some trip ups
Well, that’s all pretty straight forward, if not completely logical. But there are some things to watch out for. Here’s a couple without going into too much detail or claiming that this is everything that could cause problems!
Themes need to be set up individually for every slide master you create in your template.
The notes master has its own separate theme. As does the handout master.
If you use chart templates (we’ll cover that in a separate blog post) and copy a chart from one PowerPoint presentation to another using a different theme, the original theme travels with that chart and can override the theme in the presentation you’re pasting it into. This mechanism is cunningly called “theme override” and can cause presentation designers and users to literally tear their hair out! In some cases, you may select a colour from the PowerPoint theme colour picker and the chart element is displayed in a completely different colour!
If you have custom colours in your theme, you’ll see them in PowerPoint and Word and sometimes in Excel, depending on what you’ve selected. Custom colours don’t appear in the Excel colour picker if you’re working in cells. That includes the text, fill and border colours.
What about mass deployment of Office themes?
While themes and templates are easy to set up on your own computer, it’s more common for IT teams to deploy these files centrally using administrator tools such as Group Policy (GPO). Alternatively, solutions such as our BrandIn add-in for PowerPoint can take the pain out of deploying both PowerPoint and Chart templates.
Do you need help with theme and template soup? We can help unmuddy your soup bowl so to speak! Just drop us a message from our contact pageLeave a comment
Senior technical consultantView Jamie Garroch's profile
Pictures in PowerPoint can be tricky to get to grips with. Choosing the right size has an impact on both the file size of your presentation and the maximum monitor/projection size you can use without degrading quality.
If you've ever run or written a macro for PowerPoint, Excel or Word on a Windows PC you'll probably be familiar with the Developer tab. Move over to the Mac and you'll be able to turn on the Mac Developer tab for both Excel and Word but it simply doesn't exist for PowerPoint. Until now!
The launch was a success! Thank you so much for delivering even against the extreme turnaround time.Mila Johnson InComm