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.