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?