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.

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

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 …

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.

In the Custom AutoFilter dialog box, in the box or boxes on the right, enter a number or numbers. For example, to filter by a lower number of "25" and an upper number of "50", enter 25 and 50.

You can apply an AutoFilter to fields in any sheet view. In addition to standard filters, project provides AutoFilters, visible at the top of each column in sheet views.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

It displays the Advanced Filter dialog box instead of the AutoFilter menu. You type the advanced criteria in a separate criteria range on the worksheet and above the range of cells or table that you want to …

Verwenden Sie den AutoFilter, um einen Datenbereich in Excel 2010 zu filtern und zu erfahren, wie Sie Filter entfernen.

Excel adds an AutoFilter dropdown menu to the first cell of each column in the range. In the table header of the column you want to filter, press Alt+Down arrow key.