I really don’t like wasting time.

It’s not very often that I need to use symbols in Excel, and I can never remember what fonts and letters will give me the symbol I need. So, I created this very simple, single page Icon Font Cheat Sheet for Excel.

If you don’t like wasting time, and occasionally use symbols, this cheat sheet has you covered. It covers Webdings, Wingdings, Wingdings 2 and Wingdings 3. Both upper case and lower case letters. Plus all of the numbers and 31 other symbols.

The point is to save time. Save the cheat sheet to your computer, or bookmark this page. Then the next time you need to remember how to get check mark in Excel, you’ll have the answer at your fingertips!

If you find yourself wasting time in Excel, come check out our other solutions.

Icon Font Cheat Sheet



System Requirements & General

Icon Font Cheat Sheet

Download 27.48 KB 1696 downloads
Icon Font Cheat Sheet - Excel

How To Use The Cheat Sheet

  • Download the icon cheat sheet. You can download this free excel template by clicking the download link above.
  • Find the icon you want to replicate. For example, let’s say you need a smiley face. It’s near the middle of the sheet. Use the font type Wingdings and the character (in this case an upper case J) to recreate it.
  • Another, even easier way to get the icon you want is to copy and paste. Find the icon you need, make a copy and paste it into the workbook you need it.

More Options

It may be that you need more icon options than are provided in the simple cheat sheet above. If that’s the case try these options out:

Option 1

In Excel, go to Insert on the ribbon.

On the far right side, click on the Symbol option.

From here, you can view all of the Symbols available by font. Simply scroll down to Webdings, Wingdings, or Symbol and see what’s included.

Option 2

This is by far the most robust solution.

Use the =CHARA() function.

Starting with a value of 33, for example =CHARA(33), you’ll get a icon or some other character. This works from 33 – 255.

Simply adjust the font type (i.e., Webdings, Wingdings, etc) and the result will change.

Not only does this option provide more options because you’re not limited to the number of keys on the keyboard, but you can also use this to solve various problems.

Check out this video by Contextures for some good examples:

On June 10, 2018   /   How To, List, Useful Resources