How do I fit a drop down selection box to an excel spreadsheet?

I am trying valiently to add a workable drop down selection box to my excel spreadsheet and just cant seem to get it to work...Any and all advice would be appreciated.