Autocomplete can be useful, so I don’t want to turn off, but how do I reject a suggestion?
So for example if another cell contains “a b” and I want to type in just “a” then 2 options are:
- “a” followed by 2 spaces followed by return, but this adds 2 spaces to end of “a” that I don’t
- “a” following by any character, then delete character and then press return
These both involve pressing 3 keys after what I typed, rather than the normal single “return” key - also tried pressing enter at same time as pressing Shift or Ctrl, or Alt and these don’t work, but this is what I am looking for - a single key or key combination I can press which accepts what I have actually typed and not the autocomplete suggestion.
Or can I change autocomplete so that “return” does NOT select suggestion and I have to press some other key (like F2) to select suggestion, so that pressing “return” always enters into the cell what I have actually typed, but autocomplete is still on.