# How to Filter Data in Microsoft Excel

> To filter data in Excel, select a cell in your range, go to the Data tab, and click Filter. Click the filter arrow to choose Text or Number Filters, set a comparison, enter your criteria, and click OK. Alternatively, unselect All, check desired values, and click OK.

Canonical: https://livedemo.ai/tutorials/how-to-filter-data-in-microsoft-excel/
Apps: Microsoft, Excel
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a3df5ab56e05a00fe5ada/preview?step=1

## Steps

1. Select a cell within your range or table.
2. Go to the Data tab and click Filter .
3. Click the filter arrow, select Text Filters or Number Filters .
4. Choose a comparison (e.g., "Between").
5. Enter filter criteria and click OK .
6. Click the filter arrow, uncheck Select All , then check the boxes for the values you want to display, and click OK .