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.

On the Data tab, in the Sort & Filter group, click Advanced. To filter the list range by hiding rows that don't match your criteria, click Filter the list, in-place.

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 …

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

In Power Query, you can include or exclude rows based on a column value. A filtered column contains a small filter icon ( ) in the column header. To remove a column filter, select the down arrow next to the …

In order to see the whole database again or perform another Filter process, you're going to have to clear the view of your last Filter. Go back to the Sort & Filter under the Data tab and click Clear, the …

To make sure your workbook doesn't contain unexpected data in filter caches, remove the filters and re-apply them.

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:

In order to see the whole database again or perform another Filter process, you're going to have to clear the view of your last Filter. Go back to the Sort & Filter under the Data tab and click Clear, the …

But these rows make it harder to summarize the data, so you can remove them with a simple filter. In more complex scenarios, you might end up performing a series of filters to get what you want.