> For the complete documentation index, see [llms.txt](https://docs.roboteasy.tech/studio-en/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roboteasy.tech/studio-en/studio/objetos/excel/incluir-filtros.md).

# Filter Columns

Object for filtering Excel worksheet columns.

## Settings 

{% hint style="info" %}
This object depends on the use of the **"New Excel"** or "**Open Excel**" object to work.
{% endhint %}

![](https://1031980850-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-MRKcZBCSfHjT8BRPnSe%2F-MVI7C45sd4lcd6CZ4I0%2F-MVIBF7csSCrtil4X_hS%2Fimage.png?alt=media\&token=dc1e671d-bf23-4320-82cf-88c9344c1014)

| Field              | Descriptive                                 |
| ------------------ | ------------------------------------------- |
| Title              | Object title                                |
| Select Main Object | Option to select an Excel spreadsheet       |
| Column             | Column that will be filtered                |
| Filter Criteria    | Option to enter the criteria for the filter |

## Example

To filter columns in an Excel spreadsheet file you need to follow a few steps:

1 - Select the "**Open Excel**" object from the "**Excel**" menu and drag it to your working area.

* First you must define a unique name for the object in the "Object Identifier Name" field, inform the complete directory containing the name and the extension of the file and then set a password if it is required.

2 - Then select the **"Filter Columns**" object from the **"Excel"** menu, select the main object defined when opening Excel and enter the column. Finally, enter the criteria for the filter (type and click "Enter")