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.