The text auto-complete function sometimes picks-up on what we want half-way through what we're typing, and at other times it just annoys us!
But next time you're preparing a list in a column with repeat entries above it, try the following combination of keys: Alt + Down Arrow
It will give you a list of relevant items you've already entered above to choose from, and as a bonus it's alphabetically-ordered too:
