# Filtering Data

**Filters narrow a Sheet down to the rows you care about, without touching your underlying data.**

![Applying filters to a Sheet](/images/filter.gif)

## What filters are for

- **Finding a subset**, for example "US orders in the last 30 days", so you can focus your analysis.
- **Validating data**, for example "rows with missing values", so you catch issues early.
- **Preparing cleaner inputs** for Pivot Tables, Charts, and Dashboards, so downstream results are accurate.

## Apply filters

1. **Click** the **Filter** icon, or press `Cmd/Ctrl + Shift + F`.
2. **Add** one or more conditions (column, operator, value).
3. **Combine** conditions with **AND** / **OR**.
4. **Click** **Apply Filters**.

## Save filters for reuse

1. **Define** your filters as above.
2. **Click** **Save Filters**.
3. **Name** the filter.
4. **Reuse** it later from the saved filters dropdown.

## Common variations

- **New Sheet from a filtered view**: persist a filtered subset as its own dataset, so you can keep working with it like any other Sheet.

## Notes

- Filters hide rows in the view. They do not modify the underlying Sheet.
- Filters apply on the active Sheet only. Apply them again on any new Sheet derived from it.

## Related pages

- [Pivot Tables](/docs/pivot-tables)
- [Creating Visualizations](/docs/creating-visualizations)
- [Building Dashboards](/docs/building-dashboards)