How to Filter Data in Microsoft Excel
- George Apostolov
How to Filter Data in Microsoft Excel: step-by-step guide
Select a cell within your range or table.
Go to the Data tab and click Filter.
Click the filter arrow, select Text Filters or Number Filters.
Choose a comparison (e.g., "Between").
Enter filter criteria and click OK.
Click the filter arrow, uncheck Select All, then check the boxes for the values you want to display, and click OK.
Quick answer: 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.
About this Microsoft tutorial
Sort and refine your data efficiently in Microsoft by using text and number filters, setting comparisons, and selecting specific values to display. This guide shows how to filter Data in Microsoft Excel in 6 steps, starting with "Select a cell within your range or table" and finishing with "Click the filter arrow, uncheck Select All , then check the boxes for the values you wa...". The interactive demo above is a click-through copy of the real Microsoft interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to filter Data in Microsoft Excel?
6 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Microsoft data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Microsoft and Excel. Related guides: How to find average in microsoft excel, How to Find Duplicates in Microsoft Excel and How to Find Missing Numbers in a Sequence Using Microsoft Excel. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
