data validation?

lets say you have a list in D2:D10

select any other cell, eg B2, then from the DATA menu, select Data
Validation from the Data Tools group

in the data validation form, set Allow to LIST and the source to =D2:D10
if the table D2:D10 is rangenamed, eg dataList , then in the validation form
source put =dataList

click OK to close the data validation form.




"Hairy" wrote in message
...
Please Help as I am at my wits end
I am new to the group and I am working on excel 2007 version. Could
somebody
PLEASE help me how to create dropdown menus in excel.
--
Hairy Gerry