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 you filter data, entire rows are hidden if values in one or more columns don't meet the filtering criteria. You can filter on numeric or text values, or filter by color for cells that have …

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.

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

The criteria range has column labels and includes at least one blank row between the criteria values and the list range. To work with this data, select it in the following table, copy it, and …

When you filter data, entire rows are hidden if values in one or more columns don't meet the filtering criteria. You can filter on numeric or text values, or filter by color for cells that have …

Select a single cell in the column you want to sort. On the Data tab, in the Sort & Filter group, click to perform an ascending sort (from A to Z, or smallest number to largest).

To sort by a part of a value in a column, such as a part number code (789- WDG -34), last name (Carol Philips), or first name (Philips, Carol), you first need to split the column into two or more …

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 …

For more information see Create, load, or edit a query in Excel. Select the filter arrow in any column header to filter your data, and then select a filter command, such as Date/Time Filters …