FILTER function | Microsoft Support
How to use the FILTER function in Excel to filter a range of data based on criteria you define.
Filter data in a range or table in Excel | Microsoft Support
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. …
Filter by using advanced criteria | Microsoft Support
Overview of advanced filter criteria Advanced Filter works differently from Filter in several important ways. It displays the Advanced …
Clear or remove a filter | Microsoft Support
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 …
Filter Function | Microsoft Support
The FILTER function returns a zero-based array containing subset of a string array based on a specified filter criteria.
Quick start: Filter data by using an AutoFilter | Microsoft Support
Use the AutoFilter to filter a range of data in Excel 2010 and learn how to remove filters.
Filter data in a workbook in the browser | Microsoft Support
To filter data, the workbook author must remove these nonprinting characters or replace them with a printing character. Calculated …
Filter for unique values or remove duplicate values
How to filter for unique values in Excel, remove duplicate values, and more.
Change the level of protection in the Junk Email Filter in Outlook
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 …
Excel help & learning - support.microsoft.com
Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.
Use AutoFilter to filter your data | Microsoft Support
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 …
Reapply a filter and sort, or clear a filter | Microsoft Support
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 …
Filter data (Power Query) | Microsoft Support
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, …
Use slicers to filter data | Microsoft Support
Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current …
Filter for or remove duplicate values | Microsoft Support
You can filter for unique values to temporarily hide duplicate values, and you can remove duplicate values to permanently delete …
Filter data in a query | Microsoft Support
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 …
Filter by font color, cell color, or icon sets | Microsoft Support
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 …
Filter data in a PivotTable | Microsoft Support
Filter data in a PivotTable with a slicer Select any cell within the PivotTable, then on the Pivot Table Analyze tab, choose Insert …
Sort data in a range or table in Excel | Microsoft Support
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 & …
Use Outlook's built-in search filters | Microsoft Support
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 …