up vote 0 down vote favorite
share [g+] share [fb]

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?

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

link|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
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard