Excel Themes and Styles
How to style your Excel outputs
Last updated
How to style your Excel outputs
Last updated
In Models, you can set a specific theme for any Model, or use a default theme, set in the .
You can create as many themes as you like. Each Theme comprises:
An , which sets the color scheme for your Model
A set of , which instructs Models how it should format different types of cell in your Excel output
You can create and edit Themes in the Themes applet, accessible from the , or from any Themes picker.
You can set the Theme for a Model in two ways:
Use the Default theme for all Models
Set a specific theme for an individual Model
Default themes are set by navigating to Edit > Edit settings, and selecting/creating a Theme in the Default Theme page of the wizard. This Theme will automatically be applied to any new Models.
To set a specific theme for a Model, in the , open the Model settings bar, and click Edit in the section. This will open a wizard in which you can set the Theme to be used in the Model.
To generate spreadsheets, Models must have access to an Excel color scheme file (.xml extension). Models comes installed with a default Theme File, but you can change to a color scheme of your choosing at any time.
When you create a new Theme File item, you will be asked to select a .xml color scheme file from your computer, which Models will copy to your data folder locally.
There are several ways of creating one of these files, including from within Excel, Word or PowerPoint. Below are the steps to create a scheme from Excel (modern versions).
Open any spreadsheet in Excel
Navigate to Page Layout > Colors
Click on Customize Colors... at bottom of list
Use the dialog box to edit your color scheme, enter a Name for it, and click Save
Your color scheme will be saved as [Name].xml in C:\Users\[Your User Name]\AppData\Roaming\Microsoft\Templates\Document Themes\Theme Colors
Styles allow you to select formatting options for certain types of cell in the Excel output that Models produces, such as headings, input cells and calculation cells.
The Themes wizard shows you how each type of cell is currently formatted, and allows you to choose a color and font style.