Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i see more than first 1000 unique entries filters dropdow..
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 |
#2
|
|||
|
|||
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" wrote in message ... 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 |
#3
|
|||
|
|||
Thanks! That was very helpful :)
"Paul B" wrote: 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" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|