Applies to: Excel for Office 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel Starter 2010.
Use AutoFilter or automatic comparison operators including “greater than” and “top 10” in Excel to reveal your preferred data and conceal those left over. After you’ve filtered data in a range of cells or table, you can choose to reapply a filter to receive the newest results, or clear a filter to present the original dataset.
Apply filters to briefly exclude some of the data in a table, allowing you to prioritise the data you must investigate.
Filter a range of data
- Choose any cell within the range.
- Pick Data > Filter.
- Pick the column header arrow.
- Choose Text Filters or Number Filters, and then pick a comparison, like Between.
- State the filter criteria and press OK.
Filter data in a table
When you add your data in a table, filter controls are instantly inserted to the table headers.
- Pick the column header arrow for the column you want to filter.
- Uncheck (Select All) and confirm the boxes you want to display.
- Click OK. The column header arrow switches to a Filter icon. Choose this icon to edit or clear the filter.