how do i see more than first 1000 unique entries filters dropdow..

Diana · Dec 13, 2004

In Excel, when using filters, only the first 1000 unique entries can be seen
when clicking on the arrow....I was wondering if that number may be increased
somehow...
Thank you,
Diana

Paul B · Dec 13, 2004

Diana, 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

Diana · Dec 22, 2004

Thanks! That was very helpful

Paul B said:
Diana, 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