Use Search While Filtering
September 07, 2022 - by Bill Jelen
![Use Search While Filtering Use Search While Filtering](/img/excel-tips/2022/09/use-search-while-filtering.jpg)
Problem: I need to select all the oil companies from the filter.
Strategy: Use the search box in the Filter dropdown.
Open the filter dropdown and type oil in the search box. Excel shows a list of the companies with Oil in the name. By default, (Select All Search Results) is chosen.
![Type oil in the filter Search box. Five choices appear, with all but the 2nd checked:
Select All Search Results
Add Current Selection to Filter
Chevron Oil
Exxon Oil
Texaco Oil](/img/content/2022/09/LE10000645.jpg)
If you do a second search, you can either choose to replace the current filter with the new results, or to add the new search results to the existing filter.
![Search for Canada. By choosing Add Current Selection to Filter, you will get all customers with Oil or Canada in their name.](/img/content/2022/09/LE10000646.jpg)
The result is all customers with either “oil” or “Canada”.
![The results in the grid: Chevron Oil, Shell Canada, Exxon Oil, and so on.](/img/content/2022/09/LE10000647.jpg)
This article is an excerpt from Power Excel With MrExcel
Title photo by Andrew Ridley on Unsplash