Hi everyone,

Say you are using Data - Validation - List where you add options like
this 1,2,3,4

Assume now you are doing this for every single cell in a matrix 5X5 for
example.

At one point, you want all cells in the matrix to be blank. I tried
this for each cell: 1,2, , 3,4

But when I tried it, it did disregard the blank option!!? How can I
overcome that?

Also, how can I automate that so I don't have to do this for every
single cell (blank case only?

Thanks,
Mike