Hi Katie

There is a limit
http://www.contextures.com/xlautofilter02.html#Limits

You can use EasyFilter maybe (No problem there)
http://www.rondebruin.nl/easyfilter.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Katie" wrote in message ...
In Excel 2000, I have a spreadsheet that the filter worked fine. I used it
for a lot of "contains" filtering. It now appears that since I've added
additional text to some cells, when I do a filter, I'm not seeing all the
unique values in the drop down filter list. I've checked the area selected
and this is fine. Any recommendations?