In this chapter you will learn how to apply data filter on a text field.
We will apply data filter on below data sets –
![Data set for apply filter](https://www.pk-anexcelexpert.com/wp-content/uploads/SortAndFilter/Sort-and-Filter-1.jpg)
- Select the entire data range.
- Go to Data tab>>click on Filter or you can use Keyboard Shortcut Alt+D+F+F or Shift+Ctrl+L
![Filter Option](https://www.pk-anexcelexpert.com/wp-content/uploads/SortAndFilter/Sort-and-Filter-18.jpg)
- Open the the filter drop down on any field
- Click on Select All checkbox.
- Now tick the field name whatever you want to filter.
- Click on OK button. Filter will be applied on selected items.
![Filter the data](https://www.pk-anexcelexpert.com/wp-content/uploads/SortAndFilter/Sort-and-Filter-2.jpg)
Below are the steps to clear the data filter:
- You can use Keyboard Shortcut Alt+D+F+F or Shift+Ctrl+L to remove all filters.
- Or go to Data tab>>click on Filter to remove all filters.
- To remove the filter from individual field, open filter drop down on that field and click on “Clear filter from (Field Name)“
![Clear Filter from Individual Field](https://www.pk-anexcelexpert.com/wp-content/uploads/SortAndFilter/Sort-and-Filter-3.jpg)
Filter by Search:
We can use search option to filter data. Type anything in the search box, list will be filtered accordingly.
![Filter by Search](https://www.pk-anexcelexpert.com/wp-content/uploads/SortAndFilter/Sort-and-Filter-36.jpg)