> 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/sheets.md).

# Sheets

## Overview

Just like in Excel, Layouts in Models are divided into Sheets. Each Sheet in Models represents a sheet that will be generated in Excel.

There are 5 types of Sheet that you can create:

<table><thead><tr><th width="235">Sheet type</th><th>Details</th></tr></thead><tbody><tr><td><code>Assumptions</code></td><td>Contains <a href="/pages/lKKb1F1UoMrL4fwDOlzA"><strong>Assumptions</strong></a>. All inputs to the Model will be editable from an Assumptions sheet, unless they are linked to a <a href="/pages/qlnsJIgl2o0vuBpEBUAg"><strong>Dashboard</strong></a> or <a href="/pages/LlprtcifdW5gSbFciKmY"><strong>Excel Insert</strong></a>.</td></tr><tr><td><code>Calculations</code></td><td>Contains <a href="/pages/CNJPIhA5uMXlyhXkn4Lo"><strong>Variables</strong></a>. </td></tr><tr><td><code>Metrics</code></td><td>Contains <a href="/pages/SDQ8HMQdp0pBauRpUIDL"><strong>Metrics</strong></a>.</td></tr><tr><td><code>Dashboard</code></td><td>Contains a <a href="/pages/qlnsJIgl2o0vuBpEBUAg"><strong>Dashboard</strong></a>. Each Dashboard sheet can only display one Dashboard.</td></tr><tr><td><code>Excel Insert</code></td><td>Copy of a pre-built sheet from another spreadsheet (e.g. a cover sheet). Read more about Excel Inserts <a href="/pages/LlprtcifdW5gSbFciKmY"><strong>here</strong></a>.</td></tr></tbody></table>

{% hint style="info" %}
You can only have one type of item (Assumptions, Variables, Metrics or Dashboards) on each Sheet in the Layout.
{% endhint %}

### Auto-generated Sheets

Depending on your Model, some auto-generated Sheets may be added to your Layout. For instance, if any of your Variables use Dimensions, a `Dimensions` Sheet will be added.&#x20;

These Sheets:

* **Can** be moved
* **Can** be [**hidden**](#hide-sheet-in-excel), or have their [**tab color**](#tab-color) changed
* **Cannot** be deleted

## Sheet Setup page

Sheets can be created directly in the **Sheets tab** of the [**Model Editor**](/models/model-editor.md), or from within any Sheet selector (e.g. in an **Add Item wizard**).

{% hint style="info" %}
Depending on the type of sheet you are creating, and which part of the UI you are creating it from, you will see different pages in the Sheet wizard. For `Dashboard` and `Excel Insert` sheets, for instance, you will see pages allowing you to choose the items to show on the sheet.
{% endhint %}

All sheet dialogs contain the **Setup page**, which will look similar to the below:

<figure><img src="/files/xH6hUYIfZGLD7OwedM6Q" alt="Screenshot of the new Sheet setup step" width="563"><figcaption><p>Sheet <strong>Setup page</strong></p></figcaption></figure>

### Sheet name

Each sheet must have a name that meets Excel [**sheet name rules**](https://support.microsoft.com/en-us/office/rename-a-worksheet-3f1f7148-ee83-404d-8ef0-9ff99fbad1f9). If you enter a name that has already been used elsewhere in your Layout, Models will automatically change it.

### Sheet description (Optional)

Adds a description to the Sheet when generated, shown in the top left of the sheet, as below.

<figure><img src="/files/wTnkPBpwa5CQdNc3gh1F" alt=""><figcaption><p>Sheet description</p></figcaption></figure>

### Time period (Calculation sheets only)

Specifies whether the Sheet's time period is the default period of the Model (as defined in [**Timings**](/models/home-tab/creating-a-model/timings.md)) or an aggregated time period.&#x20;

If you have [**Variables**](/variables/variable-basics.md) that are [**aggregated**](/variables/variable-basics/variable-setup.md#time-period) over several time periods (e.g. in a quarterly Model, you may have a Variable that sums up totals for each year), these must be placed on a dedicated Sheet with the appropriate time period.

{% hint style="warning" %}
Each sheet can only show one type of time period e.g. you cannot have a Sheet that shows both quarterly and annual periods
{% endhint %}

### Control sheet

One Sheet in the Model must display the dropdown controls for selecting the active Scenario and Sensitivity, as shown below.

<figure><img src="/files/dsFRa2hJwTlz19KeC814" alt=""><figcaption><p>Sheet with dropdown controls for Scenario and Sensitivity</p></figcaption></figure>

Use the toggle to specify whether this Sheet will display these controls. If you select this option on one Sheet, it will be deselected on all other Sheets.

### Group levels

You can specify a number of levels to group your [**Line Groups**](/layout/sheets/sheet-content.md#line-groups-and-lines) by in your generated spreadsheet. By default, the value is `0`, meaning no Excel grouping is performed.

{% hint style="info" %}
Use grouping on large or complex Sheets to help speed up navigation of the Excel.
{% endhint %}

<figure><img src="/files/ntrXjdvXGWnZJ3RZbAqS" alt=""><figcaption><p>Generated spreadsheet with 2 levels of grouping</p></figcaption></figure>

### Hide sheet in Excel

If this item is selected, the Sheet will be [**hidden**](https://support.microsoft.com/en-us/office/hide-or-unhide-worksheets-69f2701a-21f5-4186-87d7-341a8cf53344) in Excel.

### Tags

You can apply [**Tags**](/tags/introduction-to-tags.md) to your Sheet to help search Sheets in large Layouts.

### Tab color

You can select a color for your Sheet, which will be used to change the color of its tab in Excel, as shown below.

<figure><img src="/files/YROyNpTiTpOSQjVBoHTe" alt=""><figcaption><p>Sheets with edited tab colors</p></figcaption></figure>