I have a number of words in a Calc column that I update occasionally. When I type a new word in a cell, it will autocomplete if I already have one higher up in the column. This is useful so I don't make duplicate entries.
However, this doesn't work for older entries (words that I've entered a longer time ago). How can I make it check the entire column, including old words?