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.