Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I see more than 1000 autofilter drop down items
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I see more than 1000 autofilter drop down items
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 "Bob I" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I see more than 1000 autofilter drop down items
10,000
http://blogs.msdn.com/excel/archive/...01/487920.aspx Conan Kelly wrote: 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 "Bob I" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I see more than 1000 autofilter drop down items
Craig
In versions earlier than 2007 the limit is 1000 items will be shown. You can use a custom like "contains" or "equal to" etc. See Debra Dalglesih's site for other workarounds. http://www.contextures.on.ca/xlautofilter02.html#Limits Gord Dibben MS Excel MVP On Tue, 11 Dec 2007 09:01:01 -0800, 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFilter and unique items | Excel Discussion (Misc queries) | |||
how to expand the autofilter range 1000 to 10000? | Excel Worksheet Functions | |||
Autofilter counting sorted items | Excel Discussion (Misc queries) | |||
Printing slected items after using autofilter | Excel Discussion (Misc queries) | |||
AutoFilter only filtering first 1000 | Excel Discussion (Misc queries) |