To get a dropdown list go to Data-Validation.

For details refer to http://www.contextures.com/xlDataVal02.html

I don't have the answer to the second part at this moment.

"Dobbin0_4" wrote:

Is there a way to add a drop down menu list to a specific cell in Excel 2007?
I thought i used one in 2003 but cannot find anything like it in 07.

If there is is there a way to then link the selected option form the list to
a sperate worksheet or even work book?


Thanks any help is greatly appreciated.