Is there a limit to how far excel will search a list for autocomplete?

  • Thread starter Thread starter Bluejay
  • Start date Start date
B

Bluejay

Auto complete doesn't work for my entire list of 4200 rows. List has
no empty cells, sorted alphabetically and all upper case. Is there
something wrong with my list or is there a limit to the list length?
 
Yes, I did some investigations some years ago and discovered that
there were limits, but I can't remember what they were and I haven't
been able to retrieve the post with the details in.

Hope this helps.

Pete
 
It answers my question, but how am I going to get auto complet for
ther other 4000 entries?
 
Back
Top