Method for inserting a check-mark/tick-box in Excel

[Guest]

It would be useful if I could have a box in Excel.

When I click on it I want it to turn from a square to square with an
'X' in the middle (or something similar)

(the purpose is so that I can quickly 'tick' tasks off when I have
done them)

 

[Guest]

Go to

View--> Toolbars--->Then go to Commands... scroll down and click on Forms

In the forms commands you should see the check box that you need.

 

[Guest]

hi.
another way that i use...
Format the cell(s) to font marlett.
the letter A puts a check mark in the cell
the letter R puts an X in the cell

Regards
FSt1

 

[ato_zee]

I found a narrow RH column A1 downwards, conditionally formatted
with a formula to change the cells colour, give me a column where gaps
show unentered data; that is uncompleted tasks.
=(A3>0) is the formula, and I set color to red for this condition.
A3 being assigned a value is a completed task.
I then copied and extended the format downwards through A1 to Ann.
It's much easier to spot gaps in a black, red, or other colored line.
Might be useful.