> For the complete documentation index, see [llms.txt](https://help.taglo.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.taglo.io/layout/excel-formatting/excel-themes-and-styles.md).

# 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**](/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**

![](https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2FHHTlpXRQJPEbPbYJSnKf%2Fimage.png?alt=media\&token=77a4062d-e89c-42a7-bcf3-119727509b5e)

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

![](https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2FVjqv5F6irdxt0H3k1I1N%2Fimage.png?alt=media\&token=377569c2-223d-4082-acbf-6a339096e0a0)

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

<img src="https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2FMB37RlthkuwhDGOJflva%2Fimage.png?alt=media&amp;token=e0f61bd0-7b80-42f0-aa1c-5eb0855e7d05" 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*

![](https://2847533834-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVy65sax6FVoNo2UTlJ0x%2Fuploads%2FOMrCglMOED1Ws0hpXCCY%2Fimage.png?alt=media\&token=455ac49c-c8fc-4184-b4e7-123a841ce9b6)

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