After filtering on Owner, if only one item shows in the first column use that
column's custom filter to filter on that one item, then remove your Owner
filter.

The custom filter is the option that appears immediately above the Select
All check box


"Chris Wisehart" wrote:

Sorry but I cannot keep this short. Say we have two columns the first column
list some Items and the second the the Owners. In Excel 2003 I could Auto
Filter and select an Owner from the second column which I can do in Excel
2007. However in 2003 I could then choose the first column drop down and
restrict the Item then remove the restriction on the second column to see all
owners of the Item. However in 2007 if there is only one item listed in the
first column I cannot choose to filter on just it as the Select All box
checks ever time I check the one item. How do I do this in 2007?