drop down list in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I set up a drop down list in excel and wanted to know if there was a way to
set up a predictive text feature so that i don't have to scroll through the
entire list to select the correct entry. i would like to be able to type in
the first two letters and have the entry appear.
 
If you use the data>validation it is not built in, you need a combobox from
the control toolbox

--
Regards,

Peo Sjoblom

(No private emails please)
 
As Peo said, if you created the dropdown lists by using data validation,
it doesn't support autocomplete.

If you can use programming, there are instructions here for adding a
combobox from which you can select one of the values from the data
validation list. In the combobox, you can enable autocomplete:

http://www.contextures.com/xlDataVal11.html
 
You must log in or register to reply here.

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

Formatted cell column in drop down list 1
drop down list 3
Drop Down List 1
Excel 2007 / right-click / pick from drop down list 1
AutoComplete Feature in Drop Down Lists? 7
Starting drop down lists at the top 1
Drop Down Lists 2007 10
can I autopopulate from a long drop down list in Excel? 2

Back
Top