Excellent explanation koolsid

You could also explain how to copy the List to any number of cells.

For example:
Select the range of cells you would like the List to be applied to and then do the above example.

By dragging the cell with the Data Validation across or down to however many cells you want it to apply to.

A great example of something fairly simple, but SO SO useful.

Thanks