can you create a list? I usualy have on another sheet select a range and
name the range , then in the Data validation, do list and "=rangename"

I did see where if you do list and even put a space and comma then the
items, it does not show a blank first , but the way above does.

"wild turkey no9" wrote:

Using the list option, I have six entries that are separated by commas
entered in the data validation source box. These work fine. How to I add a
blank space as the first choice on the dropdown list?

Thanks

Kevin