The dropdown list can only display 1000 items but you can overcome that

http://www.contextures.com/xlautofilter02.html#Limits

--
Regards,

Peo Sjoblom


"Charlene" wrote in message
...
Is there a maximum number of records allowed in Auto-Filter?