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
|