Enable Autocomplete

When i enter the just a letter, what all item name starts with that particular name will be displayed. for example when we enter the 1st letter in google search same like that.

Im not sure if this is possible and would let our experienced team to check. In the meanwhile I have a workaround.

1. Go to Tools>Options - Edit and check Enable AutoComplete for cell values
2. Move your list of items is in the range immediately above the Validation cell.
3. Hide the rows above your Validation cell.

Now, as you type Excel will look at the list above the Validation cell and AutoComplete based on it.

Note - As your list is too large, the autocomplete would take sometime until it reaches the closest option available.

You should change the title of your 1st post, not the later ones.

I have done it for you this time. Please remember for future use.

Click
File Menu under it the "option button" just below the help button.

choose advance---

it's the 7th tick box. - enable autocomplete for cell values...