View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default how to expand the autofilter range 1000 to 10000?

"master777" wrote:
How can I expand the excell autofilter range 1000 to 10,000? Also how could I
create a search engine for my excell data base in order to search and fine
what I am looking for in a thousands of datas?


Don't think that is possible,
but you could try Debra Dalgleish's page at:
http://www.contextures.com/xlautofilter02.html#Limits
Limits to Dropdown Lists (workarounds)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---