Entry into one cell clears other cells
 

I have a series of 10 cells, and I only want to be able to select one of the
cells. Therefore, if I put an "x" in one of the 10 cells, I want the cell
that currently has the "x" in it to clear out.
Thanks

Entry into one cell clears other cells
 

are you trying to make a "radio button" type thing for data entry? If you do
a lot of that, this might help:

http://support.microsoft.com/kb/873209

"bkala" wrote:

I have a series of 10 cells, and I only want to be able to select one of the
cells. Therefore, if I put an "x" in one of the 10 cells, I want the cell
that currently has the "x" in it to clear out.
Thanks