Inserting a Check mark in an Excel Cell

[G118]

I want tp place a check mark and an "X" inside cells for
a comparative chart analysis. In Word I go to INSERT,
Symbol and select, but how do you do it in excel? I
don't want to use the x key but rather the one similar to
the one found in symbol look up of Word. Thanks

 

[Norman Harker]

Hi G118!

First change the font using Format > Cells > Font and select Wingdings
from the drop down.



With the Numlock on:



Hold down Alt and type 0252. On releasing Alt it produces ü



An alternative is to change the font to Marlett and type lower case a.



You can use similar approaches to inserting other characters such as
the x that you like.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.