AutoComplete will only match on exact cell entries and not on individual words within a cell. This feature is on by default although you can switch if off by changing your (Tools > Options)(Edit tab, Enable AutoComplete for Cell Values). AutoComplete does not work on numbers or when editing any formulas.
Answers & Comments
Answer:
true
AutoComplete will only match on exact cell entries and not on individual words within a cell. This feature is on by default although you can switch if off by changing your (Tools > Options)(Edit tab, Enable AutoComplete for Cell Values). AutoComplete does not work on numbers or when editing any formulas.