Remove all the filters in a worksheet If you want to completely remove filters, go to the Data tab and click the Filter button, or use the keyboard shortcut Alt+D+F+F.

After you have filtered or sorted data in a range of cells or table column, you can either reapply a filter or perform a sort operation to get up-to-date results, or you can clear a filter to redisplay all the data.

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 table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.

How to use the FILTER function in Excel to filter a range of data based on criteria you define.

You can filter for unique values to temporarily hide duplicate values, and you can remove duplicate values to permanently delete duplicate values. A duplicate value is one where all values in the row are an exact match of all values in another row.

In Excel, there are several ways to filter for unique values—or remove duplicate values: To filter for unique values, select Data > Sort & Filter > Advanced. To remove duplicate values, select Data > Data Tools > Remove Duplicates.

On the worksheet, select the column you want to use to filter for unique records. You could also use the Remove Duplicates button on the tab, depending on what you want to achieve, because this will delete duplicate records, not just filter them.

Use the AutoFilter feature to find, show, or hide values—in one or more columns of data. You can filter based on choices you make from a list, or search to find the data that you seek. When you filter data, entire rows will be hidden if the values in one or more columns don't meet the filtering criteria. Follow these steps to apply an AutoFilter:

Use the AutoFilter to filter a range of data in Excel 2010 and learn how to remove filters.

How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.