Insert symbol in cell

M

Maurice

working with excel 2003 want to insert the "check mark" in certain cells.
Could not find it in insert, symbols. Would prefer to just click the mouse
in the cell but configuring a keyboard combination would work as well.
Guidance sought.
 
M

MyVeryOwnSelf

working with excel 2003 want to insert the "check mark" in certain
cells. Could not find it in insert, symbols. Would prefer to just
click the mouse in the cell but configuring a keyboard combination
would work as well.

It's a little effort to use a mouse click, but here's one way.

1. Right-click in the tool bars and make the Forms tool-bar appear.

2. Click on the check box in the Forms tool-bar and then on the worksheet.
This makes a check box appear on the worksheet.

3. Move and re-size the check-box to suit.

4. Right-click on it and use "Edit Text" to change its label.

5. Right-click on it and use
Format control > Control > Cell link
to assign a cell that will track the on/off status of the check box.
Use that cell for calculations depending on the status.

There are other choices in "Format control" to fine-tune the appearance of
the check box, if needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top