Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
So you should close this question. –  DaveParillo Nov 8 '09 at 1:43
Post your findings as to why it can't as an answer itself. Then accept it a couple of days later. No need to delete. –  random Nov 8 '09 at 9:27

1 Answer 1

Update from author of question, moved from question to this answer:

I've found that it only remembers the last 200 entries.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.