How to insert checkmark in excel?

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
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,215,227
Messages
6,123,738
Members
449,116
Latest member
alexlomt

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