Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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.