How to Filter Cells in Excel

This post will guide you how to filter cells in one given column in your worksheet. How do I filter cells based on certain criteria in one column in Excel.

Filter Cells in One Column

Assuming that you have a list of data in range A1:B5, in which contain product names and sale values. And you want to filter all product names that sale values are greater than or equal to 50. How to do it. You can use Filter feature to achieve the result. Here are the steps:

#1 click Column B letter to select the entire sales column.

filter cells1

#2 go to DATA tab, click Filter command under Sort & Filter group to turn on filtering on the selected column. Then one filter arrow would be added in the first cell of column.

filter cells2

filter cells3

#3 click the arrow button in the first cell of sales column. And select Number Filters from the popup menu list, and select Custom Filter sub menu. And the Custom AutoFilter dialog will open.

filter cells4

#4 select is greater than or equal to in the Sales list box, and enter number 50 in the second box. Click Ok button.

filter cells5

#5 you would notice that all of the products have been filtered out based on one criteria.

filter cells6

Leave a Reply