---
title: "Hide Filtered Columns in Tree Filters"
slug: "hide-the-filtered-column"
description: "Hide the database columns used by a Tree or cell filter from the Excel table. Values are still filled in from the filter selection."
updated: 2026-11-05T16:48:06Z
published: 2026-11-05T16:48:06Z
canonical: "sqlspreads.com/hide-the-filtered-column"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://sqlspreads.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Hide a filtered column from the spreadsheet

When you use a Tree or Cell parameter filter, you can hide the database columns that are used in the filter from the Excel table: ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28180%29.png)

When you hide those columns, the inserted values will always be taken from a selected Tree Filter item or a cell value.

In the example below we use a Tree filter, but the process is the same for filtering on a cell value.

#### 1. Add a row filter in the SQL Spreads Designer

After you have created your Tree filter you will have to add a Custom SQL Filter in the Designer to apply the Tree filter selection to the data loaded from SQL Server: ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28150%29.png)

To quickly insert a Tree Filter parameter or a Cell parameter, click the **Quick Add** button above the filter text area: ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28151%29.png)

#### 2. Specify which Tree Filter that holds the columns value

Before hiding the column, you must specify which Tree filter that holds the selected value for that column. To do that, go to the Columns tab in the SQL Spreads Designer and click the small cog on the right side of the column's row: ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28148%29.png)

Click the **Quick Add** button above the **Parameter to use as value for this column** field... ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28152%29.png)

... and select the Tree Filter value to use for this column: ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28154%29.png)

#### 3. Hide the column

You can now hide the column by unchecking the Show checkbox in the SQL Spreads Designer: ![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28153%29.png)

Using the same technique, you can hide all the filtered columns:

![image.png](https://cdn.document360.io/ad9d65b3-9cdd-4b28-8cb8-86cb149873bc/Images/Documentation/image%28149%29.png)