How do I create a drop down list for every cell in a column?

[jomol05]

I read the tutorial but it only refers to a single cell to add the drop down list to, but I want to set it up for the entire column and as I add rows to my spreadsheet I would like for that drop down to appear in that column for that row automatically. Is this possible or are the DD lists only for a single cell?

[optomyst]

No you can copy down data validation.. use paste special.. that will help.

[jomol05]

Thanks - I can copy to the next row below it but as I add rows to my spreadsheet I would like for that drop down to appear in that column for that row automatically