How do I see more than 1000 autofilter drop down items

C

Craig

Hi

I have a long list of over 12,000 individual company names...yet when I
apply an autofilter to the list and click the down arrow besides company
name, it only lists the first 1000 items so I cant scroll down and see all
the companys in the drop down list Do you know why this is so? Got any
ideas on how I can list all of the companys in the drop down list?
thank you very much!!

Craig
 
C

Conan Kelly

Bob I,

Do you know what the maimum number of items listed in the AutoFilter's
drop-down's is for XL 2007?

Thanks again for all of your help,

Conan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top