# Excel Themes and Styles

## Themes

In Models, you can set a specific theme for any Model, or use a default theme, set in the [**Application Settings**](/models/home-tab/application-settings.md).

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

1. An [**Excel Theme File**](#excel-theme-files)**,** which sets the color scheme for your Model
2. A set of [**Styles**](#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**](/using-taglo-software/the-taglo-interface/navigating-in-models.md), 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**](/models/model-editor.md), open the Model settings bar, and click **Edit** in the [**Model settings**](/models/model-editor.md#model-settings-bar) 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**

![](/files/JGuPBC9o8WxOJHxYy8Mn)

* Click on **Customize Colors...** at bottom of list

![](/files/bBIs6xfDVRkFseO12XpH)

* Use the dialog box to edit your color scheme, enter a **Name** for it, and click **Save**

<img src="/files/hcFhfpSl70vdjmNBYyal" alt="" data-size="original">

* Your color scheme will be saved as ***\[Name].xml*** in *C:\Users\\**\[Your User Name]**\AppData\Roaming\Microsoft\Templates\Document Themes\Theme Colors*

![](/files/QUzNfrbJBQj2NHYKCnV2)

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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.taglo.io/layout/excel-formatting/excel-themes-and-styles.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.