Excel Themes and Styles

How to style your Excel outputs

Themes

In Models, you can set a specific theme for any Model, or use a default theme, set in the Application Settings.

You can create as many themes as you like. Each Theme comprises:

  1. An Excel Theme File, which sets the color scheme for your Model

  2. A set of Styles, 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 Navigation Bar, or from any Themes picker.

Default and Model Themes

You can set the Theme for a Model in two ways:

  1. Use the Default theme for all Models

  2. 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 Model Editor, open the Model settings bar, and click Edit in the Model settings section. This will open a wizard in which you can set the Theme to be used in the Model.

Excel Theme Files

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.

Creating a .xml color scheme

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).

Exporting a color scheme from Excel

  • 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

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.

Last updated