In an worksheet...
Create the list of values you want in your dropdown. This list can b
anywhere on your worksheet. For this example, have cells A1 through A
be "Yes", "No", and "N/A", respectively.
Select the cell where you want your dropdown.
On the Menu Bar, select DATAVALIDATION
In the ALLOW dropdown, select LIST
In the SOURCE field, either hit the icon to manually let you selec
your range on the sheet, or type =$A$1:$A$3
Hit OK, and your cell will have those values available in a dropdown

--
Message posted from http://www.ExcelForum.com