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

J

Joy 13883

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

How to make repeating drop-down lists? 2
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Auto-Completion on Drop-Down Lists 2
How do I designate dates using info from a cooresponding drop down list? 3
Drop down lists in excel 3
drop down list based on other drop down list pick 1
Linking Excel drop down lists 2

Top