# Manage inserted rows

Plan allows you to manage rows inserted in a visual, such as calculated rows, static rows, template rows, or data input rows, using the **Manage Rows** option.

In this article, you learn how to manage inserted rows using options such as search, filter, show, and hide.

### Manage an inserted row

You can manage inserted rows (such as static and calculated rows) using the **Manage Rows** option. A list of inserted rows is displayed, and each row type (calculated, aggregated, data input, and template) is identified using icons.

To manage an inserted row,

1. Go to **Planning** > **Insert Row** > **Manage Rows** > **Rows** or **Template Rows.**
2. The **Inserted Rows** side panel opens. Hover over a row to view the available management options.

<figure><img src="/files/2rwtHxk2UJn7PqDmcMVj" alt=""><figcaption></figcaption></figure>

#### Available actions

* **Add rows**: Add child rows or sibling rows (at the same hierarchy level) directly from the **Manage Rows** pane.
* **Edit**: Modify formulas or other row properties.
* **Show or hide rows**: Temporarily hide inserted rows.
* **Delete**: Permanently remove inserted rows.
* **Show row indicator toggle**: Show or hide the pencil icon displayed next to inserted rows.

<figure><img src="/files/f6iOvN93gFylHSFwZvcr" alt="" width="375"><figcaption></figcaption></figure>

* **Search and filter:** Search for a particular row category or filter rows based on the type.

<figure><img src="/files/aNtkRGqalSAEM1dUnn05" alt="" width="375"><figcaption></figcaption></figure>

### Row settings

The **Manage Rows** pane includes a **Row Settings** tab that allows you to configure settings for inserted rows.

<figure><img src="/files/xif0apjYbmUIT5AuB7zN" alt="" width="375"><figcaption></figcaption></figure>

#### Insert row configuration

Use **Insert Row Configuration** to control the types of rows that can be inserted. You can define category-based rules for bulk row insertion.

The following options are available:

* **Text** – See [*Text*](/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-manual-input-rows.md#insert-a-row-hierarchy)
* **Distinct Values** – See [*Distinct Values*](/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-manual-input-rows.md#insert-distinct-values-as-rows)
* **Disable Insert Row** – See [*Disable Insert Row*](/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-manual-input-rows.md#disable-row-insertion)
* **Options list from CSV** – See [*Options list from CSV*](/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-manual-input-rows.md#upload-rows-from-excel-or-csv)
* **Allow Blank Values** - See [*Allow Blank Values*](/planning-sheets/how-tos/adding-business-logic-and-formulae/rows/insert-manual-input-rows.md#allow-blank-values-in-categories)


---

# 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://docs.fabricplan.com/planning-sheets/how-tos/adding-business-logic-and-formulae/manage-inserted-rows-and-columns.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.