"Show Top 10" AutoFilter option does not flter Excel for Mac worksheet rows (270074)


The information in this article 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.

REFERENCES

For more information about how to use AutoFilter, click the Office Assistant, type Ways to find values in a list by using filters, click Search, and then click a topic to view it.

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar.
Modification Type:MajorLast Reviewed:2/10/2005
Keywords:kbprb KB270074
©2004 Microsoft Corporation. All rights reserved.