Double Filtering in Excel 2007

[Guest]

Greetings. I am using Excel 2007, and I have a question about filtering in
Excel 2007, but I can't find an answer in the help file.

If in Col. B I filter a certain cell in a row I get a very handy list. If I
then (maintaining the same filter) filter another cell in a row in Col. C I
get another handy list (smaller than the first filtered list, of course).
Let's say I want to switch back to the first filter, kind of backtracking. I
found that when I release the second (sub-)filter, both filters are removed
(the same thing happens in Access). Is there an easy way to backtrack
filters? If so, please explain in easy English. Thanks.

 

[Roger Govier]

Hi Rebecca

How do you >release the second (sub-)filter ?
If you just click on the filter dropdown, and choose All, then the
selection form the first filter should still be visible.

If you choose Data>Filter>Show All, then all filters will be released.
I haven't yet installed my copy of Excel 2007 so I don't know if it
behaves differently from previous versions of Excel - but I doubt that
it is.

 

[Guest]

Hi, again, Roger. Thanks for the always useful advice. By accident I found
that you can filter on the fly in Excel 2007, so to speak. If I place the
cursor in a particular cell and right click the mouse, select Filter, then
Filter by Selected Cell's Value, then a nice long filtered list appears, as
expected. If I do the same in another cell in this filtered list, I get a
nice shorter list, as expected. But in 2007 (and I am guessing this is not
the case in previous versions), if I finish with this sub-filter, all I have
to do is click on the filter icon at the top of the shorter list, and, viola,
I am back in the first filtered list. This is exactly what I need. Thank
you MS Excel 2007. I can hardly wait to buy the product.

 

[Roger Govier]

Hi Rebecca

Thanks for posting back and sharing this with us.
Just as soon as I complete the current project I am working on, I will
load XL2007 and try it. I daren't do it before as I know I won't stop
"playing" <bg>

 

[Nick Hodge]

Rebecca

I'm really interested in what you like and what standard you would class
yourself at with Excel. I am involved in a group where there is quite a
debate on the pros and cons and am interested in a view from a user not
'tainted' by the earlier releases and who is using it in earnest

Just a short bullet list would be great

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Guest]

My Excel level? Using math as an analogy, I would be in elementary school,
struggling with third grade arithmetic (adding, subtracting, maybe
multiplication and some division).

By the way, Nick, I posted to the "Suggestions to Microsoft" regarding the
need for a subfilter removal icon, only to find that only if enough people
recommend this suggestion will the MS Excel people take a look at the
suggestion. This doesn't seem to be a very good method, because a lot of
good suggestions might fall through the cracks, so to speak. Just a thought.

 

[Nick Hodge]

Rebecca

I will submit this for you as a wish/suggestion, through a tool early beta
testers have. (don't hold your breath though or else you will go blue!)

Done

MS info- Tracking No 408594219

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[gls858]

Rebecca

I will submit this for you as a wish/suggestion, through a tool early beta
testers have. (don't hold your breath though or else you will go blue!)

Done

MS info- Tracking No 408594219

Giving the blue screen of death a completely different meaning

gls959