Filter

[Ronald Guenot]

Hi,

I work with a lot of spread sheet with filters, With Mac Excel I can not
filter mutable number, For example, If I want to only filter 3 different
number between 1 and 1,000. Let say number 3, 400 and 950 and cannot do
that I can only filter one number at a time.
Also when you open your filter and want a number that maybe down the list
you have to wait for it to scroll down instead of scrolling down with your
mouse.

Please help!!

Thank you, Ron

 

[CyberTaz]

Yes, the AutoFilter is limited in all versions of Excel -- PC or Mac --
except for Excel 2007. For more advanced criteria use the Advanced Filter
feature instead. It's totally missing from Excel 2008 Help but the info for
Excel 2003 is virtually identical:

<http://office.microsoft.com/en-us/excel/HP052001781033.aspx?pid=CH062527971
033>

I'm afraid I don't understand what you mean by your second question.

HTH |:>)
Bob Jones
[MVP] Office:Mac