Autocomplete Data Validation Drop Down

Hello,

I was wondering if there is a way to make my Data validation list autocomplete as I type?

For example:

I have some lists with over 50 entries. Instead of having someone scroll down to find what they want, as they type B, the first 3 B words (or however many) would show up etc...

Thank you!

For my excel (2016) I believe it will autocomplete as long as what you are trying to type already exists in the data validation list.

Let’s refer to link in the following thread which discusses about a similar and see if it helps: http://www.contextures.com/xlDataVal02.html

@ProudSmitty I don't have 2016 but thanks.

@AmandaWilso This has a lot of info but nothing about auto-complete.