Creating a drop down menu basics

I am trying to create a drop down menu in an excel worksheet, but am having trouble entering the source.  When I try the formulaic approach eg. =Catagories(A2:A9) I get exactly that as the drop down menu, not the items in those cells.  When I list the items in the list with commas between I'm told there are too many characters.

Any help is appreciated.