Pinterest Pixel

How to Use Wingdings Characters in Excel

Wingdings Characters are a symbolic font that a lot of us use for fun. I do that... read more

Download Excel Workbook
Bryan
Posted on

Overview

How to Use Wingdings Characters in Excel | MyExcelOnline How to Use Wingdings Characters in Excel | MyExcelOnline

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:

How to Use Wingdings Characters in Excel

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 workbookHow-to-Use-Wingdings.xlsx

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

How to Use Wingdings Characters in Excel

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

See also  Dynamic Data Validation List

How to Use Wingdings Characters in Excel

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

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

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

How to Use Wingdings Characters in Excel

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

How to Use Wingdings Characters in Excel

 

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

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

How to Use Wingdings Characters in Excel

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

How to Use Wingdings Characters in Excel

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

How to Use Wingdings Characters in Excel

The arrow symbol will now be inserted in the cell.

See also  Best Guide: Create Meetings from Emails in Outlook!

How to Use Wingdings Characters in Excel

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

How to Use Wingdings Characters in Excel

 

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

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

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

How to Use Wingdings Characters in Excel

STEP 2: Enter the CHAR Function.

=CHAR(

How to Use Wingdings Characters in Excel

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

See also  How to Calculate Standard Deviation in Excel: A Detailed Tutorial

How to Use Wingdings Characters in Excel

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

How to Use Wingdings Characters in Excel

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

How to Use Wingdings Characters in Excel

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

How to Use Wingdings Characters in Excel

 

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

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

How to Use Wingdings Characters in Excel

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

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.

 

See also  Merge Multiple Excel Files: Quick and Easy Guide for 2024

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!

Further Learning:

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

How to Use Wingdings Characters in Excel | MyExcelOnline

If you like this Excel tip, please share it
How to Use Wingdings Characters in Excel | MyExcelOnline How to Use Wingdings Characters in Excel | MyExcelOnline
How to Use Wingdings Characters in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...