Why doesn't autocomplete work...

[robertdseals]

Hello,
Does anyone know why autocomplete doesn't work if the name you are looking for is more than 102 cells away. I put Joe in cell A1. Then I put Jim in cells A2:A102. When I try typing Joe again, it auto completes. However, if I put Jim in cells A2:A103 and try to put Joe in cell A104...it doesn't auto complete (I'm using Excel version 2010).

 

[Dryver14]

Not really sure on the benefits of this.. if we are really talking about longer words you can add them to the autocorrect options in the options proofing tab.
it has a replace holder and a with, you could for instance put stu in replace and stupified in the with box, then when you type stu and press enter on the sheet it will complete the word for you.
useful if you want to abbreviate company names etc

 

[Eric W]

Interesting. I've duplicated your results. This link:

https://answers.microsoft.com/en-us...120-rows/f1a82077-74c9-4050-9dd3-76662e283d81

says there is a limit, and offers some workarounds. The limit (120) isn't exactly what you found though. This link:

https://answers.microsoft.com/en-us...cel-2016/2eb68e81-849b-4815-b1f3-e5b57b1ac508

says that there is no limit in Excel 2016 - however, that's what I'm using and I duplicated your issue. So I don't have a good answer for you.