G
Guest
Greetings. I am using MS Excel 2007 (beta), and it's a peach, to say the
least. I especially like the improved filtering functions. There is one
thing, however, that I hope you will include in the final version scheduled
to come out next year.
When I filter the contents of a particular cell (right mouse click, filter
by selected cell's value, etc.), and then in a different column filter on the
contents of another cell within this first filter, I get another smaller
"subfilter," of course. After doing something to the contents in this
subfilter (filling in a blank, for example), I want to go back to the first
filter. I don't want to clear all filters (there is an icon on the ribbon
for that), I only want to clear the current filter (the subfilter). To do
this (clearing the subfilter) I have to go to the top of the column, click on
the filter icon, whereupon a "box" opens, and then I have to click on "Clear
Filer from "...". Then I am back to the first filter.
Is there any way this process could be streamline or speeded up, say by
including a shortcut key or by having an option to customize the ribbon so as
to include a "Clear Subfilter from "..." icon? I know it sounds like I'm
spoiled, but I will have to use filters and subfilters frequently, and having
this feature would save a lot of keystrokes.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...d86436ae18&dg=microsoft.public.excel.newusers
least. I especially like the improved filtering functions. There is one
thing, however, that I hope you will include in the final version scheduled
to come out next year.
When I filter the contents of a particular cell (right mouse click, filter
by selected cell's value, etc.), and then in a different column filter on the
contents of another cell within this first filter, I get another smaller
"subfilter," of course. After doing something to the contents in this
subfilter (filling in a blank, for example), I want to go back to the first
filter. I don't want to clear all filters (there is an icon on the ribbon
for that), I only want to clear the current filter (the subfilter). To do
this (clearing the subfilter) I have to go to the top of the column, click on
the filter icon, whereupon a "box" opens, and then I have to click on "Clear
Filer from "...". Then I am back to the first filter.
Is there any way this process could be streamline or speeded up, say by
including a shortcut key or by having an option to customize the ribbon so as
to include a "Clear Subfilter from "..." icon? I know it sounds like I'm
spoiled, but I will have to use filters and subfilters frequently, and having
this feature would save a lot of keystrokes.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...d86436ae18&dg=microsoft.public.excel.newusers