Try copying the first cell down as far as you want.

"wanderer83" wrote:

I have created a drop down list for the first cell in the column using the
data, validation method but I want the list for each cell in the column. How
do I do this without having to go to each cell to create the list?