Microsoft KB Archive/270074

= &quot;Show Top 10&quot; AutoFilter option does not flter Excel for Mac worksheet rows =

Article ID: 270074

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Excel 2004 for Mac
 * Microsoft Excel X for Mac
 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q270074



SYMPTOMS
When you apply AutoFilter to worksheet columns, and you attempt to display a subset of rows by using the Show Top 10 option, Microsoft Excel for Mac may simply beep and not return any results.



CAUSE
The Show Top 10 option of the AutoFilter feature does not work with alphanumeric data. It works only with numeric data.

