How to filter data in a range or table in Microsoft Excel
Use AutoFilter or built-in comparison operators like "greater than" and "top 10" in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or tables, you can either reapply a filter to get up-to-date results or clear a filter to redisplay all of the data.