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?

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?

I cannot do this if there is only one Item the Select All checks every time I
check that item to limit the item search to just it. This works if the Owner
has more than one Item one can limet the Items to one or more than uncheck
the Owner filter. This appears to be a bug as I should not have to have two
to select just one.

"Duke Carey" wrote:

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?

Well, I did get the custom filter to do the trick. So now instead of two
clicks I get to make five. No wonder my peers won't move to 07???

"Duke Carey" wrote:

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?