Choose a different autocomplete option in Calc

I’m working in a column where many values start with the same pattern, like “First”, “First but goes after second”, “First and third”, "Sixth, “Sixth and eleventh”, etc. Only some of those values are frequent, let’s say “First” and “Sixth” appear in multiple cells, while the others are unique cases. However, Calc’s autocomplete always suggests the wrong option; so if I start typing “First” it suggests “First but goes after second”, forcing me to delete the extra text each time, all because a previous cell happened to use it once.

Is there a way to choose a different option, like with a drop down menu or something similar, or to make the autofill not suggest certain values?

For clarification: I do not want to disable autocomplete, I want to continue using it but I want it to autofill the correct value.

Perhaps the combination of keys Ctrl+Tab will solve your problem?

@JohnSUN It does help, thank you! Any way to delete unwanted suggestions though?

Well, if you can accurately explain to us which ones are unwanted - we can try together to explain the same for Calc :slight_smile:

@JohnSUN Well, as I explained in my example, if I have “First”, “First but goes after second” and “First and third”, only “First” is a wanted suggestion and I’d like to remove the others.

In other words, do you need the shortest of variant? Does Calc not offer the first exactly this - the shortest of the options for substitution?

If you press Alt+Down Arrow (as recommended here), will the list be sorted alphabetically?

Actually there is something different: data-validity, where you can provide a list of your frequent items, omitting rare results. However in my setup there is a penalty: If I wish to enter something else, I have to confirm it in the resulting warning.
.
This is Independent from auto-fill/auto-complete.

I’m having a similar concern: I’m making a list of purchased items for an insurance claim; one of the columns is ‘where purchased’. Somewhere along the line I misstyped ‘Home Deopt’ instead of ‘Home Depot’. The autocomplete now has a death-grip on the misspelling and wants to enter it every time and I cannot find where to remove the misspelling. I’d like to leave the autocomplete on as it is a time saver. I’ve google searched and this forum thread is the most relevant thing I’ve found.

I just would like to summarize suggestions from comments here.

When an auto-completion suggestion is shown inside a cell (after a character is typed, suggested text is selected):

  • Ctrl + Tab cycles through all auto-completion values for the cell, on every key press, selected suggested text is replaced with the next suggestion
  • Alt + Down shows a pop-up select box under the cell with all auto-completion suggestions sorted alphabetically
1 Like

Excellent summary!
However, the functionality seems to have changed recently. Ctrl + Tab now cycles through sheets, rather than auto-completion values for a cell. If anyone can tell me how to restore the functionality described by @ferenczy , I would greatly appreciate it.

Ctrl+Tab still works but you need to enter 3 letters minimum to give a suggestion, I think.
Alt+Down doesn’t need any letters filled in.
See AutoInput