Excel

name the list which you have created.

Do this by selecting the list and then clicking on the top left hand address cell (where it normally says A1) and change this to the Name of the list "MyList" for example.

Then go to the cell that you want to have the drop down list. Click on Data and then Validation, and click on the Settings tab.

Choose "List" in the Allow box,
in Source, enter the name of your list but preceded with an = sign i.e. =MyList

You should then see that that cell becomes a drop down box.

i got this a few months ago from this web site.

http://office.microsoft.com/en-us/excel/HP052022151033.aspx