Enable Autocomplete

[Shilpa kanchan]

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.

[bonny24tycoon]

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.

[Shilpa kanchan]

Where is tools option in excel

[Shilpa kanchan]

Where is the "autocomplete for cell values" option

[arlu1201]

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.

[vlady]

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...

[Shilpa kanchan]

It's not working Bonny

[Shilpa kanchan]

[jocer]

click the Office button logo at the top Left Hand corner and you will see there below excel options(click it) and follow vlady instruction.
Hope this help