Thread: How do I see more than 1000 autofilter drop down items
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
  
Posts: 2,819
Default How do I see more than 1000 autofilter drop down items
Office 2007

Craig wrote:

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

Reply With QuoteReply With Quote