Quick start: Filter data by using an AutoFilter - Microsoft Support
With filtering, you can control not only what you want to see, but what you want to exclude. You can filter based on choices you make from a list, or you can create specific filters to focus on exactly the data …
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. Once you filter data in a range of cells or table, you can either reapply a …
FILTER function - Microsoft Support
How to use the FILTER function in Excel to filter a range of data based on criteria you define.
Filter by using advanced criteria - Microsoft Support
To filter the list range by hiding rows that don't match your criteria, click Filter the list, in-place.
Filter data in a workbook in the browser - Microsoft Support
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 …
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 make from a list, or search to find the data that you want to see. When …
Filter for unique values or remove duplicate values
To filter for unique values, select Data > Sort & Filter > Advanced. To remove duplicate values, select Data > Data Tools > Remove Duplicates. To highlight unique or duplicate values, from the Home tab, …
Filter data (Power Query) - Microsoft Support
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 …
Filter data in a PivotTable - Microsoft Support
PivotTables are great for creating in-depth detail summaries from large datasets. You can insert one or more slicers for a quick and effective way to filter your data. Slicers have buttons you can click to …
Filter data in a query - Microsoft Support
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 when you want to …
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 filtering state, which makes it easy to understand what exactly is …