• Excel Book Excerpt

Excel Use Search While Filtering

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Use Search While Filtering

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.

LE10000645.jpg 

Figure 622 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.

 

LE10000646.jpg 

Figure 623 Add a second search.

The result is all customers with either “oil" or “Canada".

LE10000647.jpg 

Figure 624 Oil or Canada appears as the result.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel:

privacy policy