AUTO SUGGEST DROP DOWN LIST

[apgmin]

Can anyone please tell me how to do this.

From Cells A1 to A9 I have a list of names

From Cells B1 to B 40 I made a data validation list so that the user can select only the names in Cell A1 to A9

Works fine,

However it will be more user friendly if the cell say B 30 while being data entered, suggests from the drop down list based on the characters input by the user so he will not have to use the cursor to select the name from the drop down list but after seeing the match just press enter to fill the cell

 

[Zot]

Non VBA method

https://www.ozgrid.com/Excel/autocomplete-validation.htm

 

[apgmin]

CANT SEE TOOLS > OPTIONS IN EXCEL 2013

 

[Rahul1987]

pls provide image with your question for the better understanding

 

[Michael M]

It should Be File>>Options>>Advanced>>Editing Options

 

[apgmin]

already did, not working

 

[Michael M]

Which solution did you try, as there are 2 in the link provided??

 

[Zot]

already did, not working

I guess by default the auto-complete is enabled

The first method needs you to put the list on rows above the validation cell which is not the way you lay out of your current sheet. This means

You list is from A1 to A9, the validation cell is at A10. You can hide all the rows above the validation cell which is A1 to A9. As you type the validation cell, the auto-complete will predict the item based on the list.

The option 2 is placing the list on different sheet which you can hide later. You can use named range as validation source.

If you go for VBA solution, you need need to use a combo box as drop-down validation list.

 

[Zot]

The VBA method

How to autocomplete when typing in Excel drop down list?

ExtendOffice provides a comprehensive range of professional software solutions, enhancing productivity and efficiency for businesses worldwide.

www.extendoffice.com