To make a dropdown first highlight the list you wish and give it a name
(anthing you want eg listX). Do this by going Insertnamecreate.
After doing this go to the cell where you wish for the dropdown list to
appear, and go DataValidation. When the box comes up, in the box next to
"allow:" secect "list". In the box below that says "source" type "=(your list
name).
For example "=ListX"

Your dropdown is then complete, so click ok.

hope this helps.

"Susan" wrote:

i want to create a dropdown list in excell that will highlight a word when
first letter is typed