I'm trying to Auto-Filter in Excel 2007. It's terrible! What did they do to
it?

In previous versions of excel, you would autofilter a column, then when
selecting the dropdown you just choose what you want to filter. Now it
seems I have to check and uncheck a bunch of boxes. Is there something I'm
missing?