How to insert checkmark in excel?

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
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
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,214,857
Messages
6,121,948
Members
449,056
Latest member
FreeCricketId

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top