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 DataFilterShow 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.

--
Regards

Roger Govier


"Rebecca" wrote in message
...
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, 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" wrote:

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 DataFilterShow 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.

--
Regards

Roger Govier


"Rebecca" wrote in message
...
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

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

--
Regards

Roger Govier


"Rebecca" wrote in message
...
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" wrote:

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 DataFilterShow 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.

--
Regards

Roger Govier


"Rebecca" wrote in message
...
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.

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
HIS


"Rebecca" wrote in message
...
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, selct 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" wrote:

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 DataFilterShow 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.

--
Regards

Roger Govier


"Rebecca" wrote in message
...
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.

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" wrote:

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
HIS


"Rebecca" wrote in message
...
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, selct 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" wrote:

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 DataFilterShow 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.

--
Regards

Roger Govier


"Rebecca" wrote in message
...
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.

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
HIS


"Rebecca" wrote in message
...
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" wrote:

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
HIS


"Rebecca" wrote in message
...
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, selct 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" wrote:

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 DataFilterShow 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.

--
Regards

Roger Govier


"Rebecca" wrote in message
...
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.

Nick Hodge wrote:
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