How do I insert a checkmark into an excel spreadsheet?

[Guest]

How do I insert a checkmark into an excel spreadsheet? The shortcut does not
work using the ALT+0252.

 

[Doug Kanter]

How do I insert a checkmark into an excel spreadsheet? The shortcut does
not
work using the ALT+0252.

If I recall, those shortcuts only work if you use the numeric keypad to
enter them, not the numbers across the top of the main keyboard area. If
you're already doing this, make sure the cell is formatted with a font which
actually contains the checkmark symbol. Wingdings is one of those fonts.

Here's a foolproof method, although it's a bit convoluted:

1) Click Start, Run, and enter charmap. At the top, switch to the Wingdings
font.

2) Scroll down to the end and you'll see a checkmark symbol. Click it, then
click the Select button, and finally, click the Copy button. The symbol is
now on the clipboard.

3) Go back to your Excel sheet and paste where you want the symbol. It will
not appear correctly until you change the font in that cell to Wingdings.

 

[neopolitan]

Try Insert>Symbols and then pick the WingDing font and highlite the
check mark symbol and click on Insert.

 

[Guest]

ü - checkmark - enter with ctrl+:,u
û - matching x - enter with ctrl+^,u

You can also copy and paste them. Change the font to wingdings to get the
marks to look like a checkmar and an x.

 

[Bob Phillips]

Letter a, marlett font.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Guest]

Enter an upper-case P in a cell and then format as Wingdings 2

 

[Dave Peterson]

And if you're really frustrated:

=char(252)

You could even copy|paste special|values if you wanted. (and copy to new cells,
too)

And from a previous post:

Insert Symbol was added in xl2002.

So if you don't run xl2002+, you'll have to find a different way.

You can hit flying windows R (or windows start button|Run)
type charmap
hit enter

or even
windows start button|Programs|accessories|System tools|charmap
if you like to mouse.

Chip Pearson has an addin that may help (if you're using xl2k or lower).
http://www.cpearson.com/excel/download.htm
(look for Symbolizer and make sure you get the correct version)

 

[Guest]

Wahoo! That was fun!

If I recall, those shortcuts only work if you use the numeric keypad to
enter them, not the numbers across the top of the main keyboard area. If
you're already doing this, make sure the cell is formatted with a font which
actually contains the checkmark symbol. Wingdings is one of those fonts.

Here's a foolproof method, although it's a bit convoluted:

1) Click Start, Run, and enter charmap. At the top, switch to the Wingdings
font.

2) Scroll down to the end and you'll see a checkmark symbol. Click it, then
click the Select button, and finally, click the Copy button. The symbol is
now on the clipboard.

3) Go back to your Excel sheet and paste where you want the symbol. It will
not appear correctly until you change the font in that cell to Wingdings.

 

[Doug Kanter]

And, you now have a source for lots of utterly useless symbols! But, some of
the other peoples' methods are faster.

 

[SharkTime]

To make a checklist in text editor you can use Unicode characters like: ☐☑☒☓✓✔.
For long list of checklist characters go here:
http://ojejej.blogspot.com/2011/08/check-characters.html

Go on page above, and copy/paste characters you need. It is simple

 

[sushil.soma]

MS Excel 2010

Insert --> Symbol-->Symbols--> Font = ZapfDingbats--> scroll down, fourth last is the tick mark symbol--> select and say insert

.