Creating a list in Excel

In Excel2000

Highlight column/cell
Choose Data->Validation
Validation criteria dropdown: choose list
In the source box, put in the values as a comma-delimited list. Click ok when done (once or twice, I forget).

You now have a real dropdown,complete with as little arrow.

HTH
~nikki~

If your list would be rather long, just type it somewhere in a column of cells. Give it a range name, say MYLIST. Refer as source for the list to =MYLIST [including the equal sign] in your validation screen. You can set the validation as to stop if no value from the list is entered or as a warning allowing other values as well. You can open the list with the mouse or ALT down arrow when being in the cell.
NOTE 1. Always use a range name if the list would not be in the same sheet as the one inwhich you are referring to it. If it would be in another workbook, first link it to the one in which you are using it and give it there a range name.
NOTE 2. This works in Excel 97, 200 and XP.
You could also make forms with drop down lists. That is much more complicated.
Good luck.