creating a dropdown list in excel

[Guest]

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

 

[Guest]

To make a dropdown first highlight the list you wish and give it a name
(anthing you want eg listX). Do this by going Insert>name>create.
After doing this go to the cell where you wish for the dropdown list to
appear, and go Data>Validation. 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.

 

[Debra Dalgleish]

You could add a data validation list to the cells in the column. There
are instructions in Excel's help, and here:

http://www.contextures.com/xlDataVal01.html

Although data validation doesn't support autocomplete, there's a sample
file here that provides a combobox from which you can select one of the
values from the data validation list. In the combobox, you can enable
autocomplete:

http://www.contextures.com/excelfiles.html

Under 'Data Validation', look for 'Data Validation Combobox'