Don

Good thoughts. I was aware of using separate lists, but for this sheet I
wanted to define the list as users may add or delete rows. Just cannot figure
out how to add a blank option this way.....

"Don" wrote:

I usualy have all my lists on another page. select the range and name the
range. Then on the location you want a drop down, choose data / validation
and list and =rangename

I did see where when you do a data / validation and put a blank then comma
then the list, it does not show the blank. above will work or put a "."
first?

"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