How to Insert a Checkmark Symbol in Excel

by Matthew Kuo on April 3, 2016

in Visual Design

To learn more about Excel, go to the organized listing of all my Excel tutorial posts or review the
 

Excel Checkmark 01

The following is a fairly quick tip within Excel Visual Design.  One of the things I like to put in tables is a checkmark symbol to indicate that something is complete.  In certain situations, it’s more appealing than writing the word “Done” or “Complete.”  There are multiple ways to do this and I’ll cover them in the order of how frequently I use them.

Click here to download an example of the checkmark symbol in Excel

Use the Wingdings 2 Font and SHIFT + P

The first approach is the one I use most frequently and what I consider the quickest way to get the checkmark symbol.

Within the HOME tab of the Ribbon, change the font to “Wingdings 2.”

Excel Checkmark 02

Then, all you need to do is put in a capital “P” by hitting SHIFT + P.

Excel Checkmark 03

As a bonus, if you put in a capital “O” with Windings 2 font, you also get a more stylish “X” symbol which you can use to indicate tasks that are not yet complete or failed.  While this probably isn’t the most intuitive approach, it’s generally one of the fastest ways to get a checkmark in your Excel file.  Wingdings 2 is a standard font within the Microsoft Office Suite, so this works for Word and PowerPoint as well.

Please note that the green and red coloring was added as an additional step.  This can be done pretty easily with either conditional formatting or custom number formatting.

Google the Word Checkmark

Googling for “checkmark” (or “check mark” as Google recommends) is another easy way to get the checkmark symbol.  Your actual search results may vary, but below is an example of the results that I get.

Excel Checkmark 04

From here, all you have to do is manually copy any occurrence of said checkmark symbol and paste it in Excel.  Just use the simple shortcuts CRTL + C and then CTRL + V.

Use Insert Symbol

The final option is to use Excel’s insert symbol feature.

Within the INSERT tab of the Ribbon, click on the “Symbol” button to the far right.

Excel Checkmark 05

From here, you can basically navigate to the checkmark symbol we used before by selecting the Wingdings 2 font and finding the checkmark symbol.

Excel Checkmark 06

While this is the most intuitive way to insert a checkmark symbol, it does take a little bit more time to leverage, especially if it’s not one of the most recent symbols you have used.  However, it does let you consider more checkmark options visually.  For example, using a checkmark symbol with a box around it.

Click here to download an example of the checkmark symbol in Excel

{ 0 comments… add one now }

Leave a Comment

Previous post:

Next post:


Related pages


logical formulas in excel 2007vba excel formulasexcel custom format thousandshistogram creator excelexcel formula isna vlookupgaussian distribution excelcheckmarks in excelhow to remove formatting in excelucla anderson alumni directoryfind duplicate lines onlinehow do i write a formula in excelvlookup multiple instancesexcel delete rowsdelete duplicates in column exceldefinition of hlookupucla gpa requirementsexcel match vbastacked excel chartexcel tracker templatesputting in excel formulasdata matching excelwhat is the purpose of macros in excelexcel most important formulasexcel compare two columns for duplicatescreate bar chart in excel 2010what is the use of vlookup function in excelhelp with vlookup function in excelexcel lookup multiple columnshow to combine column in excelvlookup example excel 2010countifs greater thanrandom password generator excel formulaadvanced if statements in exceluid uclahow to make a stacked bar graphamazing excel chartsvlookup function helpdeduplication in exceldelete repeated rows in excelif statements excelexcel lookup tablesdownload free trial microsoft word 2010vlookup limithow to insert icon in excelexcel formatting formulaexcel remove duplicate rowexcel vba return arrayhow to create a column graph in excelvlookup in excel 2007 formulahow to label axis on excel graphexcel input formulaexcel vlookup worksheetpivot table querycommon excel shortcutsoffset in excel macrohow to insert tick mark in wordinvalid cell reference errorexample vlookupgenerate random password excelhow to excel file convert to pdfexcel 2010 if statementif iserror in excelucla summer parkingexcel 2010 if statementalexa global rankinghow to make a randomizer in excelpower query for excelexcel stacked bar chart two barsmonthly planner excel templateexcel 2013 data labelsediting charts in excelhow to do vlookup in excel 2007 step by stepucla course readervlookup false trueexcel vba nested ifcustom formats in excelexcel formulas times
\n