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

Top