I think what was being asked is how to apply the list to the entire column.
The answer is to first select the entire column, then use the Data Validation!
Bob Umlas
Excel MVP

"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?