Pre-select the range of cells to have the dropdown list.

Then create the DV list dropdown.

If you have one created already, just select that cell and a bunch below and
DataValidation

A mesage will pop up "do you want to extend etc." Click Yes then OK


Gord Dibben MS Excel MVP

On Mon, 6 Oct 2008 11:16:06 -0700, 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!