am looking for drop down suggestion list in mac excel as there are more than 500 entries which i have to fill in sheet but with data validation i have to scroll a lot to find my entry so am looking for suggestion drop list where by typing only first initial letter auto complete the word, for this i have searched on google and it was possible to do this with changing properties of combo box, as am using mac excel there am not able to see properties window for combo box.. so i want to know how to do this in macbook pro excel or is there another way to do this in mac excel