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 by using advanced criteria | Microsoft Support
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 AutoFilter to filter your data | Microsoft Support
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. When you filter data, …
Quick start: Filter data by using an AutoFilter | Microsoft Support
By filtering information in a worksheet, you can find values quickly. You can filter on one or more columns of data. With filtering, you can control not only what you want to see, but what you want to …
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 …
Reapply a filter and sort, or clear a filter | Microsoft Support
What do you want to do? Learn more about reapplying a filter and sort Reapply a filter or sort Clear a filter for a column Clear all filters in a worksheet and redisplay all rows Learn more about reapplying …
FILTER function | Microsoft Support
How to use the FILTER function in Excel to filter a range of data based on criteria you define.
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 …
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 for unique values or remove duplicate values
Learn about filtering for unique values or removing duplicate values Filtering for unique values and removing duplicate values are two similar tasks, since the objective is to present a list of unique …
Clear or remove a filter | Microsoft Support
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 …