You may have noticed that the filter option is located in the same place as the sort option.
On Home, select Sort and Filter. (You can also find the option on the Data tab.)
How to do filtering
- Select any cell in the range.
- Select Data.
- Select Filter.
- Select the Filter arrow from the column header.
- Select Text Filters or Number Filters, then a comparison, such as Between.
- Fill in the filter criteria and click Ok.