• Excel Book Excerpt

Excel Show Checkmarks in Excel

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Show Checkmarks in Excel

Problem: I have to show checkmarks in a list. How do I create a checkmark in Excel?

Strategy: Use a capital letter P and convert the font to Wingdings 2. There are actually a series of letters with checkmarks and x’s. in the P to V range.


Figure 1126 Convert to Wingdings 2 to access these symbols.

Once you have a range formatted with Wingdings 2, you would type a P to type a checkmark or type an O for the x.

Gotcha: if you start getting circled 7’s instead, it is because you are typing a lower case p instead of a capital P.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel:

privacy policy