# Filtering Rows[¶](https://knowledge.dataiku.com/latest/courses/resources/excel-to-dss/filter.html#filtering-rows "Permalink to this headline")

Excel has two separate tools for filtering rows: one that allows you to specify a simple filter on one column, and an advanced filter tool that uses filter criteria specified in worksheet cells.

In Dataiku DSS, you can create simple or advanced row filters with the **Filter recipe**, a visual tool that helps you to create filters that can be read and understood in natural language.

Alternatively, you can filter rows as a step within a script of the **Prepare recipe**.

See also

Filter recipe lessons in the Visual Recipes 101 course

Prepare recipe lessons in the Visual Recipes 101 course

Filtering and flagging rows in the reference documentation
