If it helps any (and if you haven't thought about it yet), you can click the
"(Select All)" entry twice to remove your current selections.

--
Rick (MVP - Excel)



"jonnybrovo815" wrote in message
...
Does anyone know if there is a way to change excel's 2007 autofilter
functionality back to like excel 2003 autoflilter use to work? I need to
quickly bring up like values and compare other columns based upon the
filtered values and the extra clicking of the check boxes is driving me
nuts!