, , ,

How To: Filter Range of Data in Microsoft Office Excel

Microsoft Office - kamiltech

Want create site? Find Free WordPress Themes and plugins.
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.


Don’t forget to like us on Facebook and Google+ as well as share this to your social networks to support us.

Please comment below if you have any query.

Did you find apk for android? You can find new Free Android Games and apps.
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published.