Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

How can I get Excel to auto complete the word I am typing by using predictive text from a defined list?

share|improve this question

When you're running down a column entering values, Excel will remember previous values and suggest those that are the same as you have typed previously.

Alternatively, you could use Data|Data Tools|Data Validation to define a List of comma separated values. It won't autosuggest them any different to the above, but it allows you to restrict values in a group of cells to your pre-defined list and gives you the option of selecting from a drop-down list.

share|improve this answer
Thanks Rhys, but our application outputs into Excel and can't do validation lists. It can provide the lists, at the moment the user has to manually link the relevent cell to the required value in the list. – user79661 May 6 '11 at 9:12

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .