Forum Discussion
Auto complete text in a drop down list cell
Hi everyone, Trying to do a spreadsheet and figured out how to make the drop down list box (yay). But I would like to have the option of auto completion of words when I type a few letters in...
Excel doesn't allows the drop down to Autocomplete, generally we use for Data Validation.
Therefore you have to work with Combo box, is one of the Active X controls.
Please check this link,,, I've shown how to do it all about Autocomplete.