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 …

When filtering text data, Excel doesn't distinguish between uppercase and lowercase characters. However, you can use a formula to perform a case-sensitive search.

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

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 …

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

How to find and remove duplicates in Excel. Filter for unique values in large or small datasets to clean up your worksheets and workbooks.

It's a good idea to filter for or conditionally format unique values first to confirm that the results are what you want before removing duplicate values. Note: If the formula in the cells is different, …

If your data is formatted as an Excel table, then you can quickly sort and filter it with the filter buttons in the header row. If your data isn't already in a table, then format it as a table.

Learn how to find text inside cells, when the case of the text doesn't particularly matter.

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 formatted cells, applied cell styles, or used conditional formatting.