You can position and size the rectangle within the cell using the mouse. You can delete the text, if you wish, by clicking on the text and then using the cursor keys and backspace to remove the text. Or you can replace the text with other text, if you prefer.
You can then click in a checkbox to put a checkmark (check mark, tick) in the box.
You can also change the value in some other cell to be TRUE or FALSE based on whether the checkbox is checked. E.g., suppose, Dexter is tracking his bucket list in an Excel spreadsheet. Dexter has 10 items on his bucket list and there's a Completed column (column B) and a Done column that holds the checkboxes. If I wanted to have "TRUE" placed in a cell in column B if the checkbox is checked and "FALSE" placed there if the box is unchecked, I could take the following steps:
If the checkbox I've selected is in cell C2 and I want cell B2 to be
set to "TRUE", I can select "Checked" and put
B2 in the
Cell link field.
TRUEappear in cell B2, if the cell C2 checkbox is checked.
If I uncheck the check box, the value will change to
I can then follow a similar procedure for the other checkboxes.
Granted in the simple example above, there might not be much value in
having "TRUE" for a cell in a Completed column right next to a
checked checkbox, but you could use the same technique to change the value
of a cell in another sheet, e.g., I could use
Sheet2!A2 for the
cell reference to change a cell's value in Sheet2 rather than the current
sheet, Sheet1 in this example. Note: if you change the cell reference, the
value stored in a referenced cell won't automatically go away. It will
remain there until you manually remove it.
You could use the value set in the "cell link" cell to perform some
calculation. E.g., if I set B2 to be
TRUE if cell C2 is
checked, I could check the value of B2 to determine if it is "TRUE" or
"FALSE" in a formula elsewhere in the workbook.