How to create a drop-down list in Excel? [closed]

Question

I have a column of values in Excel, like this :

How do I turn this into a drop-down list, such at each row in the column will have that drop-down list (with dog, cat , fish, bat , toad. .. all inside )

thanks !

Answer 1

You do that with list validation in the "Data" ribbon.

See here