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.
to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.