The Excel autofilter dropdown list in the column headings will only display
up to 1000 unique items. All the data records will stil be displayed. There
are workarounds...but that's the basic limitation.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Raj Mazumdar" wrote:

Hi there... have a concept question... What is it meant when it is said that
the Auto-filter works for only the top 1000 entries? Does it mean:
a) The auto-filter works in only the top 1000 rows of records. So if I have
a record that doesn't occur in the top 1000 but occurs in the 1500th row say,
then that record won't be shown on the drop-down auto-filter.
...OR...
b) The autofilter shows only the top 1000 rows when there is an occurence of
a particular record in more than 1000 rows.

Please clarify... thanks