| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
