Go to your drop-down cell, copy, then go down the row and paste!

"Robert24" wrote:

Make your list somewhere and then use Data-Validation-and where it says "any
value" choose "list" and Then choose the source of the list. When you have
done this for one cell, copy and then paste special and choose validation.

Hope this helps

"Vanmessa" wrote:

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!