Double Filtering in Excel 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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.
 
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>
 
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)
 
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.
 
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)
 
Nick said:
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
Click to expand...
Giving the blue screen of death a completely different meaning :-)

gls959
 
Back
Top