Problem: I need to select all the oil companies from the filter.
Strategy: New in Excel 2010, there is a 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.
- Results of a search while filtering in Excel 2010.
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.
- Add a second search.
The result is all customers with either "oil" or "Canada".
- Oil or Canada appears as the result.