drop down list populating

[Pammy]

I have a drop down list - When I am in the cell instead of clicking on the
drop down arrow every time, is there a way that when I type the first letter
example M the word Mugshot will automatically populate without having to
click on the down arrow? There are only 8 words in the list and none begin
with the same letter. This would make data entry faster.

 

[Gord Dibben]

If the dropdown list is a Data Validation dropdown you cannot have
autocomplete.

You need a combobox for that.

See Debra's site for instructions.

http://www.contextures.on.ca/xlDataVal14.html


Gord Dibben MS Excel MVP

 

[T. Valko]

For only 8 items this may be more work than it's worth:

http://contextures.com/xlDataVal10.html