How do I set up auto complete from a drop down list in Excel 2000.

G

Guest

I have a 10 sheet workbook that I will be sending out to various users around
the world. For their convenience, we are adding a lot of drop down lists for
them to choose from. However, since there are many options to choose from in
each list we would like for it to auto complete based on their initial
entries: Ed -> list to jump to Edinburgh, etc.... I have enabled the
AutoComplete in the cell values button in the Tools/Options/Edit tab, but it
is still not working. Any help on this matter would be greatly appreciated.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto-Completion on Drop-Down Lists 2
How do I auto populate based on a drop down list? 0
Auto complete in a validation list 1
drop down list based on other drop down list pick 1
drop down list 2
Excel Formatting in Drop Down Lists 2
Drop down list and macros? 1
Excel Excel: How do I put a formula in a drop down list 11

Top