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

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 …

Overview of advanced filter criteria Advanced Filter works differently from Filter in several important ways. It displays the Advanced Filter dialog box instead of the AutoFilter menu. You create a criteria …

In the following worksheet, a filter is available for the Product column, but it hasn’t been used. The filter in the Country column has been used to sort the data. Remove all the filters in a worksheet If you …

The FILTER function returns a zero-based array containing subset of a string array based on a specified filter criteria.

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

To filter data, the workbook author must remove these nonprinting characters or replace them with a printing character. Calculated members in PivotTable reports You cannot apply a filter that combines …

How to filter for unique values in Excel, remove duplicate values, and more.

The Junk E-mail Filter in Outlook identifies messages that are likely junk and moves them to the Junk E-mail folder. You can easily change the level of junk email protection or automatically delete junk email.

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

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 …

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. …

Select OK. Filter by using date/time filters You can filter by date/time value using the Date/Time Filters submenu. To open a query, locate one previously loaded from the Power Query Editor, select a cell …

Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is …

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 …

Filter data in a query Queries retrieve rows and columns from tables. After you run a query, you can further limit the number of items shown in the datasheet by applying filters. Filters are a good choice …

You can quickly filter data based on visual criteria, such as font color, cell color, or icon sets. And you can filter whether you have formatted cells, applied cell styles, or used conditional formatting. In a …

Filter data in a PivotTable with a slicer Select any cell within the PivotTable, then on the Pivot Table Analyze tab, choose Insert Slicer. Choose the fields you want to create slicers for, and select OK. …

To include the first row of data in the sort because it is not a column heading, on the Home tab, in the Editing group, select Sort & Filter, Custom Sort, and then clear My data has headers. Sort data in a …

To clear the search filter and view all items in the selected mail folder, click in the Search box, or on the Search tab, select Close Search. Save a custom search as a Search Folder In addition to using …