Filter for Selected Item in Excel List

Easy Filtering in Excel 2007

Last month you saw a quick way to filter for the selected item in a pivot table, and today you’ll see a similar technique for a worksheet list in Excel 2007.

Tip: For the Excel 2003 quick filter instructions see AutoFilter By Selection in Excel

In the screen shot below, there’s a list on the worksheet, with office supply orders. The list isn’t filtered, and it’s not formatted as an Excel Table.
(Note: This technique will also work if the list is already filtered, or if it’s formatted as an Excel Table.)

filterselected00

Filter for the Selected Item

To quickly focus on the Paper orders:

  • Right-click on a “Paper” cell.
  • In the popup menu, click Filter, and then click Filter by Selected Cell’s Value.
Filter by Selected Cell's Value
Filter by Selected Cell’s Value

AutoFilter Applied Automatically

An AutoFilter is automatically applied to the worksheet list, and column B is filtered for “Paper”.

filterselected02

Clear the Column Filter

To see the full list again, you can clear the filter:

  • Click the drop down arrow in the Column B heading cell.
  • Click Clear Filter From ‘Product’

filterselected03

Clear All the Filters

If you have more than one column filters, you can clear all the filters in a single click:

  • On the Ribbon, click the Data tab
  • In the Sort & Filter group, click Clear

Remove the Filter

To remove the AutoFilter completely from the worksheet list:

  • On the Ribbon, click the Data tab
  • In the Sort & Filter group, click Filter.

filterselected04
___________

2 thoughts on “Filter for Selected Item in Excel List”

Leave a Reply to Contextures Blog » AutoFilter By Selection In Excel Cancel reply

Your email address will not be published.

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