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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Diana - 13 Dec 2004 20:17 GMT

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

Reply to this Message

Paul B - 13 Dec 2004 20:30 GMT

Diana, have a look here for a workaround
http://www.contextures.com/xlautofilter02.html

Signature

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

> In Excel, when using filters, only the first 1000 unique entries can be
> seen
[quoted text clipped - 3 lines]
> Thank you,
> Diana

Reply to this Message

Diana - 22 Dec 2004 21:41 GMT

Thanks! That was very helpful :)

> Diana, have a look here for a workaround
> http://www.contextures.com/xlautofilter02.html
[quoted text clipped - 5 lines]
> > Thank you,
> > Diana

Reply to this Message