In cell drop down type ahead

[Iain]

Is there any way that you can make an in cell drop down be a type ahead
rather than a point and click?

Thanks

 

[Debra Dalgleish]

Data validation doesn't have an autocomplete feature. You can use a
combo box instead, as described here:

http://www.contextures.com/xlDataVal11.html