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. (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, [...]