Click the Filter button next to the column heading, and then click Clear Filter from <"Column Name">. For example, the figure below depicts an example of clearing the filter from the Country column.

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 …

Follow these steps to apply an AutoFilter: Select the data you want to filter. Click Data > Filter. Click the arrow in the column header and decide if you want to choose specific values or search. Choose …

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

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

To remove a drop-down list, click the cell with the list, then click Data > Data Validation, and then on the Settings tab, click Clear All, then OK. A drop-down list is also known as a drop-down box or drop …

It's a good idea to filter for or conditionally format unique values first to confirm that the results are what you want before removing duplicate values. Note: If the formula in the cells is different, but the values …

The Document Inspector found one or more active Autofilters or table filters in your workbook. These filters can be the cause of cached or hidden data in your workbook.

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