drop-down for entire column
 

How to create a drop-down for an entire column, or a row-range of a column ?

So, the user would click on the cell and the drop-down down-arror would
appear, they would click on the down-arrow and select a value.

Thanks.