How to insert checkmark in excel?

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

scrupul0us

Well-known Member
Joined
Sep 7, 2004
Messages
641
well if u are familiar with windows character map u can find one there.... just set the cells font type to symbol and paste it over from the char map...

you could also use auto shapes
 

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
Character 252 with a font of Wingdings will give you a checkmark.

To enter in a cell:
Press and hold the Alt key
On the ten-key pad, type: 0252
Press Enter
Change font to Wingdings (1)

HTH
 

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,453
Here's another way...
If the checkmark is to be the only thing in that cell:
Format the cell font to "Marlett" and enter a lower case a.

If there's to be more than just the checkmark in the same cell, enter whatever you want in whatever font you want, using a lower case a where you want the checkmark. Then (in the formula bar) highlight the lower case a and change the font on just that character to Marlett.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,128
Messages
5,576,253
Members
412,709
Latest member
Rishu
Top