Show drop down list when typing

[apar93]

Is it possible to have a validated cell show the drop down list once I begin typing something into the cell, without having to click on the arrow with my mousse?

 

[CalcSux78]

I think what you're looking is similar to auto-complete, right? If so, check out this helpful blog on the subject:<!--StartFragment-->http://www.contextures.com/xlDataVal10.html
<!--EndFragment-->

 

[apar93]

This is exactly what I'm looking for. I wish they had a video that explained this in my version of excel. But thank you!