Ml, as you have found out the list will only show 1000 entries have a look
here for a workaround

http://www.contextures.com/xlautofilter02.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"ml" wrote in message
...
When I am filtering a colum I can't see some records, when I read the help
issue it says that I can only see the first 1000 records filtered, how can
i
see more than 1000 records.