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

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)

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

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.

" wrote:

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)

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

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

" wrote:

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)

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

On 20-May-2007, ?B?RlN0MQ==?= wrote:

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)

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.
=(A30) 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.