how do I see more than 1000 records filtered

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.

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" <[email protected]> wrote in message
news:[email protected]...
> 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.