Wingdings Characters are a symbolic font that a lot of us use for fun. I do that a lot too! But what if we wanted those cool symbols to be of good use in Excel?

Whenever I tried typing using the Wingdings font, I was not sure which symbol I would get!

I will show you how easy it is to pick cool Wingdings Characters and use them in your Excel worksheet!

Here is a sample usage of Wingdings characters for stock prices:

Wingdings Characters

How to Use Wingdings Characters in Excel | MyExcelOnline

I explain how you can use Windings Characters in Excel below:

Let’s look at each one of these methods!

 

Using Character Map

Watch it on YouTube and give it a thumbs-up!

How to Use Wingdings Characters in Excel | MyExcelOnline

Follow the step-by-step tutorial below on How to use Wingdings Characters in Excel and download the Excel Workbook to move along with us:

DOWNLOAD EXCEL WORKBOOK

STEP 1: Select the cells that you want to place the symbols in:

How to Use Wingdings Characters in Excel | MyExcelOnline

STEP 2: Go to Home Tab > Font dropdown > Select Wingdings.

Wingdings Characters

STEP 3: Now that our cells are able to accept Wingdings characters, go to Windows Start (Windows 10) > Search Bar > Character Map

If you have an older version of Windows, go to Start > All Programs > Accessories > System Tools > Character Map

How to Use Wingdings Characters in Excel | MyExcelOnline

STEP 4: You will now see all the characters in the wingdings chart!  Ensure the Font is Wingdings.

Double click on the symbol you want to use. Click Copy.

How to Use Wingdings Characters in Excel | MyExcelOnline

STEP 5: Go to your Excel Spreadsheet and click Paste.

How to Use Wingdings Characters in Excel | MyExcelOnline

Do the rest for the other cells, and you have used Wingdings Symbols!

How to Use Wingdings Characters in Excel | MyExcelOnline

 

Using Symbol Menu

You can use the insert symbols option to use Windings characters in Excel.

STEP 1: Select the cells where you want to insert symbols.

How to Use Wingdings Characters in Excel | MyExcelOnline

STEP 2: Go to Insert Tab> Symbols dropdown > Select Symbol.

How to Use Wingdings Characters in Excel | MyExcelOnline

STEP 3: In the Symbols dialog box, select Windings from the font dropdown.

How to Use Wingdings Characters in Excel | MyExcelOnline

STEP 4: Select the arrow up symbol from the wingdings font chart and press Insert.

How to Use Wingdings Characters in Excel | MyExcelOnline

The arrow symbol will now be inserted in the cell.

How to Use Wingdings Characters in Excel | MyExcelOnline

STEP 5: Repeat the same steps for inserting the symbols in cell D7 and D8.

How to Use Wingdings Characters in Excel | MyExcelOnline

 

Using CHAR Function

In the previous method, you might have noticed that for every wingdings symbols there is a character code mentioned in the bottom right corner of the Symbol dialog box.

For example – The character code for the upwards arrow is 233.

How to Use Wingdings Characters in Excel | MyExcelOnline

You can use the CHAR Function in Excel to insert the character code and return the corresponding symbol.

CHAR function returns a character specified by a number from 1 to 255. For example, CHAR(254) returns a tick box (☑), CHAR(34) returns a ” (double quote), CHAR(233) returns ↑(arrow upwards), etc.

In the example below, there is a list of Order IDs and you want to add a tick box for the orders that have been dispatched.

Let’s use this CHAR function to insert a tick box in Excel!

How to Use Wingdings Characters in Excel | MyExcelOnline

STEP 1: Select the cell where you want to insert a tick box.

How to Use Wingdings Characters in Excel | MyExcelOnline

STEP 2: Enter the CHAR Function.

=CHAR(

How to Use Wingdings Characters in Excel | MyExcelOnline

STEP 3: Enter the character code of the tick box and press Enter.

How to Use Wingdings Characters in Excel | MyExcelOnline

STEP 4: Go to Home > Font Dropdown > Select Wingdings.

How to Use Wingdings Characters in Excel | MyExcelOnline

This will insert the tick box symbol in the selected cell!

How to Use Wingdings Characters in Excel | MyExcelOnline

STEP 5: Copy-paste the formula in the cells where you want a tick box.

How to Use Wingdings Characters in Excel | MyExcelOnline

 

Using Alt Codes

An easier way to insert character in Excel is to use the Alt button in a combination with the character code.

STEP 1: Select the cell where you want to insert a symbol.

How to Use Wingdings Characters in Excel | MyExcelOnline

STEP 2: Go to Home > Font Dropdown > Select Wingdings.

How to Use Wingdings Characters in Excel | MyExcelOnline

STEP 3: Press and hold the Alt button and then type the character code (0254) on your keypad.

How to Use Wingdings Characters in Excel | MyExcelOnline

This is how you can easily use the Alt button to insert windings characters in Excel. But, you need to keep the following points in mind while using this method:

  • You have to add a leading zero in front of the character code i.e. you need to type 0254, not 254.
  • You need to use the numerical keypad, not the numbers at the top of the keyboard.

 

Conclusion

To insert Wingdings Characters in Excel, you can use the character map, the symbol menu, the CHAR function, or the ALT button.

Either of these methods will get the job done for you!

 

HELPFUL RESOURCE:

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

Microsoft Excel Training

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

How to Use Wingdings Characters in Excel | MyExcelOnline

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn