Excel for Mac and autofilter - how to...?

[feuerschlange]

I use Excel 2007 in WinXP.
I ported all my work recently completely to Mac OS X.

I used the autofilter in WinXP Excel extensively.

I need a function, where I can filter several items and click/ unclick each seperately, as in Excel 2007 for Windows.

Excel for mac only allows to filter ALL, Seperate items, or maximum 2 different items at once.
It does not allow, to click/ unclick all items in a list, as is in Windows.

Is there a workaround (other than using Excel for Windows within Fusion, which works ages more fluently and seems much more polished)?

 

[exegete77]

Howdy. I think you have found one more issue that shows the inequality of 2008 and 2007. My suggestion is to use the Fusion and 2007, for you will find more limitations the more you use the advanced features.