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.

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

1 Answer 1

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

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.