How to use AutoFilter in Excel to find and work with a subset of data in a range of cells or table.

Use AutoFilter to find values, or to show or hide values, in one or more columns of data. You can filter values based on choices you make from a list, or search to find the data that you want to see. When …

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

If the data you want to filter requires criteria across multiple fields, such as filtering by multiple conditions that must all be true, or showing rows that match any of several different conditions (such as Type = …

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

Filtering for unique values and removing duplicate values are two closely related tasks because the displayed results are the same — a list of unique values. The difference, however, is important. …

Clear all the filters in a worksheet Click the Data tab, and then click Clear. How do I know if the data has been filtered? If a filtering is applicable to a table in a worksheet, you’ll see either of these buttons in …

Filtering data is a quick and easy way to create a subset of data in a range of cells or in a table column. Filtered data displays only the rows that meet criteria that you specify and hides rows that you do not …

Filtering rows by position is similar to filtering rows by value, except that rows are included or excluded based on their position in the query data instead of by values. Note: When you specify a range or …

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.

All filters are automatically cleared when you close the query. Or, you can clear a filter from a column by clicking clicking Clear Filter in the list. For more information about creating queries, see Introduction …