If the data you want to filter requires complex criteria (such as Type = "Produce" OR Salesperson = "Davolio"), you can use the Advanced Filter dialog box. To open the Advanced Filter dialog …

The Advanced Filter gives you the flexibility to extract your records to another location on the same worksheet or another worksheet in your workbook. It also allows the use of an "OR" …

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 …

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

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

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

Use wildcard characters as comparison criteria for text filters and when you're searching and replacing content. These can also be used in the Conditional Formatting rules that use the …

Learn how to highlight, sort, and filter, your tables (or data in another supported format) with Copilot in Excel.

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 …

To use a dynamic filter, click one of the predefined date commands. For example, on the All Dates in the Period menu, to filter all dates by the current date, select Today, or to filter all dates by …