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

Sheet type	Details
`Assumptions`	Contains Assumptions. All inputs to the Model will be editable from an Assumptions sheet, unless they are linked to a Dashboard or Excel Insert.
`Calculations`	Contains Variables.
`Metrics`	Contains Metrics.
`Dashboard`	Contains a Dashboard. Each Dashboard sheet can only display one Dashboard.
`Excel Insert`	Copy of a pre-built sheet from another spreadsheet (e.g. a cover sheet). Read more about Excel Inserts here.

{% 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. 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:

Screenshot of the new Sheet setup step — Sheet **Setup page**

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

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

Sheet with dropdown controls for Scenario and Sensitivity

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 %}

Generated spreadsheet with 2 levels of grouping

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

--- # 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/sheets.md?ask= ``` 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.