Not sure I totally get how you're envisioning it to work.

I'm guessing you want to click on the cell at which point it will put an x
in the cell then take it off.

2 ways to do it.

1) (I wouldn't do this) use forms, and put a checkbox over the cell. I've
found the checkboxes are always tough to manage, expecially if people are
inserting rows, resizing cells, etc.

2) Macro time. Each worksheet has a 'selectionChange' event. Use this
event. you'll have to write a conditional (if, or select) to 'trap' the
cells you want to behave like checkboxes. But then just have the code in
that routine verify if there's an X in the cell or not. If not, insert one
(using code) if so, remove it..

HTH

"danielle" wrote:

Is there a way to have a cell in a spreadsheet be represented as a symbol?

example: if i want cell A1 to show a checkmark or an x when the cell is
checked, how would i do that (if it can be done)?

greatly appreciated