Confused here, because the definition of filtering a worksheet as I understand it, is using
something like Data / Filter / Autofilter which will ONLY show the data you have filtered. If you
wanted all the 1s say, then select 1s and you will see only 1s, BUT, if you mean you want to see
what was filtered out, the hit the dropdown on the autofilter, select custom and choose 'not equal
to' and then put in your criteria from before. Now you will only see what you had previously
filtered out. If I have completely missed the plot, then post back with some more details please.
