New Search Feature in Excel 2010 AutoFilter

Last week, you saw a quick tip for filtering by selection in Excel 2007. That’s helpful when you’ve found an item in a list, and want to filter for that item.
There’s another new feature in the AutoFilter dropdown, in Excel 2010.

When you click the drop down arrow in the AutoFilter heading cell, you’ll see a new Search box, that wasn’t in previous versions of Excel.

AutoFilterSearch00

This is a great way to find an item in a really long list — much quicker than scrolling down, and scanning all the list items.

Use the Search Box

For example, if you type “ri” in the Search box, only the cities with “ri” in their name will be left in the drop down list.

In the screen shot below, “riv” is in the Search box, and only one city (Riverview) is showing — the only city with that string of letters in its name.

AutoFilterSearch01

Press the Enter key to complete the search, and the worksheet is filtered for the selected city names.

AutoFilterSearch02

Watch the Video

To see the steps in the AutoFilter Search, you can watch this short Excel tutorial video.

____________

2 thoughts on “New Search Feature in Excel 2010 AutoFilter”

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.