Auto filter in Office: Mac vs PC

Joined
Feb 11, 2009
Messages
471
Reaction score
0
Points
16
Don't know if this is the right forum.

I have a simple XLS worksheet with about 300 rows. When I apply the auto-filter in PC I can select more than one value/category per column and filter the data. However, in Mac it only appears as if I can select one value/category per column.

In PC there are small boxes to select what you want; not so in Mac.

Is it hiding from me?
 
Joined
Feb 26, 2010
Messages
2,116
Reaction score
123
Points
63
Location
Rocky Mountain High, Colorado
Your Mac's Specs
1.8 GHz i7 MBA 11" OSX 10.8.2
What version of Office are you running? I just tried Office 2011 and I have the selection box to choose more than one per column.
 
OP
T
Joined
Feb 11, 2009
Messages
471
Reaction score
0
Points
16
Then that is probably it. I should have mentioned the Office version. It is 2008.

When the drop-down menu appears and you select an option the spreadsheet automatically filters, and any subsequent selections do not work.
 

chscag

Well-known member
Staff member
Admin
Joined
Jan 23, 2008
Messages
65,248
Reaction score
1,833
Points
113
Location
Keller, Texas
Your Mac's Specs
2017 27" iMac, 10.5" iPad Pro, iPhone 8, iPhone 11, iPhone 12 Mini, Numerous iPods, Monterey
Let's get this to the correct forum. Does not belong in "Switcher".
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top