Filter a range of data

Built-in comparison operators such as “greater than” and “top 10” can show the data you want and hide the rest. That’s a big help with large worksheets or when you just want to focus on particular data ranges.

Select the data you want to filter. For best results, the columns should have headings.

  1. Click Data > Filter.

Filter button

  1. Click the arrow Filter arrow in the column header, and then click Text Filters or Number Filters.

  2. Click one of the comparison operators. For example, to show numbers within a lower and upper limit, select Between.

Number Filters Between

  1. In the Custom AutoFilterbox, type or select the criteria for filtering your data. For example, to show all numbers between 1,000 and 7,000, in the is greater than or equal to box, type 1000, and in the is less than or equal to box, type 7000.

Custom AutoFilter dialog box

  1. Click OK to apply the filter.

More filter options

Comparison operators aren’t the only way to filter by criteria you set. You can choose items from a list or search for data. You can even filter data by cell color or font color.

See Also

Filter data in an Excel table

Filter by using advanced criteria

Show or hide columns and rows

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!