how to create search suggestion drop down list in mac excel

am looking for formula or method where i can create auto fill suggested drop down list ..i have very long list of items and most of them are repeated again and again but when i type in excel cell it only suggest recent active cell information ..i have tried data validation but i have to scroll down all the entire list to look for my item...so is it possible to make auto complete typing in an excel data validation list? am using macbook pro

Take a look at Debra Dalgleish's site here:

http://www.contextures.com/xlDataVal10.html

she shows how to use a combo box which has the AutoComplete feature.

Hope this helps.

Pete

thank you but problem is after i active combo box on worksheet... am not able to see any property after right click

I don't know how a Mac differs from a PC, so I can't help you with that - sorry.

Pete

see below link for autocomplete from dropdown list

http://www.extendoffice.com/document...ocomplete.html

see below link for autocomplete in dropdownlist.

http://www.extendoffice.com/document...ocomplete.html

Hi,

http://www.contextures.com/xlDataVal10.html

In the above link the autocomplete feature using combo box.

But i need create a autocomplete feature in a cell.

If anybody know pls share.

Regards
Prasanna