I'm trying to create a spread sheet to enter data into and i've figured out
how to make a dropdown list to simplify data entry. But how can i make the
drop down list appear in evey row of a column?

I'm an excel newbie!

thanks for your help!