Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Another Filtering Question for Excel 2007 Experts
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double Filtering in Excel 2007 | New Users to Excel | |||
Excel 2007 Charting causes blank screen | Charts and Charting in Excel | |||
Question for the real experts! | Excel Discussion (Misc queries) |