How to Filter Data in Microsoft Excel

‍

‍

Here's how to do it:

‍

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.