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

[Diana]

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]

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]

Thanks! That was very helpful

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