How do I create a drop down list to use for a whole column of cells, allowing
the same set of values to be used for what will be hundrededs of rows of data
over time? Also, when I thought I had created a drop down list, the allowed
entries disappeared after being chosen just once!