The autofilter feature for Excel 2007 is far more cumbersome to use than
previous versions. Now I have to deselect all checked boxes (i know you can
click select all to unclick) and then scroll down to the one item I want to
filter on. THat is like 2-4 MORE clicks than I had to do before.

Is there any way to bring up the old way it worked? This is a step
backwards..