Hello.
I need assistance with a drop down box (I hope I am referencing it correctly). I have a list of items I would like the user to be able to select from a drop down list. I'd like the format of the cell that contains the list to 1. hide the arrow and 2. highlight an item from the list when it is typed. I tried using both data validation and a combo box. The data validation seems to be the closest to my objective - it just doesn't permit typing in the cell (or does it?). I have attached a very basic excel which includes how I formatted the data validation and the combo box. Any help will be very much appreciated!
Thank you,
Emma
Drop-down list.xlsx
Bookmarks