Greetings. I'm using Excel 2007 (beta), and it's a peach, to say the least.
I asked a question about filtering a few hours ago that was skillfully
answered (thanks, Roger). This time I have another question, but one that
only people using Excel 2007 (beta) can answer.

When I do a filter by righting clicking my mouse in an individual cell,
selecting "Filter" and then "Filter by Selected Cell's Value," the filtered
list appears, of course. At the top of the list will appear an icon,
indicating that this is a filtered list. I then do this again on another
individual cell elsewhere in this filtered list, and another shorter list
appears, which is a subfilter of the first filter. This is just the feature
I need -- filters -- subfilters -- even sub-subfilters!

When I want to remove this sub-filter, I can click on the icon (located at
the top of the subfiltered list column), but then I have to select "Clear
Filter from ..." from the choices in the box that opens. It would be nice if
there were shortcut keys for such filtering and unfiltering, but I can't seem
to find them anywhere. Also, it would be nice if this feature (clearning the
subfilter) could be placed somewhere on the ribbon as an icon. I realize
there is an icon on the ribbon that clears filters, but it clears all
filters, whereas I only want to clear the most recent subfilter and return to
the first or previous filter. Do any Excel 2007 users out there know how
this can be done, either by a shortcut key or by customizing the ribbon with
a "clear subfilter" icon?