Microsoft Support
Filter a range of data. Select any cell within the range. Select Data > Filter. Select the column header arrow . Select Text Filters or Number Filters, and then select a compariso
FILTER function | Microsoft Support
How to use the FILTER function in Excel to filter a range of data based on criteria you define.
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 …
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, …
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 = …
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 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 …
Filter for or remove duplicate values | Microsoft Support
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. …
Use filtering to modify a SharePoint view | Microsoft Support
Dec 31, 2016 · Filtering reduces the number of items displayed in a view to just the data your want to see. A filter selects items that match specific criteria, such as location, type of item, or a range of …
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 …
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 …