{"id":6270,"date":"2021-01-20T05:55:31","date_gmt":"2021-01-20T04:55:31","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=6270"},"modified":"2024-02-06T19:20:00","modified_gmt":"2024-02-06T18:20:00","slug":"how-to-use-windings-symbols-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-use-windings-symbols-in-excel\/","title":{"rendered":"How to Use Wingdings Characters in Excel"},"content":{"rendered":"<p><strong>Wingdings Characters <\/strong>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?<\/p>\n<p>Whenever I tried typing using the Wingdings font, I was not sure which symbol I would get!<\/p>\n<h4>I will show you how easy it is to pick <strong>cool Wingdings Characters <\/strong>and use them in your Excel worksheet!<\/h4>\n<p>Here is a sample usage of Wingdings characters for stock prices:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-6.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone wp-image-6277 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-6.jpg\" alt=\"How to Use Wingdings Characters in Excel\" width=\"386\" height=\"117\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-6.jpg 386w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-6-300x91.jpg 300w\" sizes=\"(max-width: 386px) 100vw, 386px\" \/><\/a><\/p>\n\n<p>I explain how you can use Windings Characters in Excel below:<\/p>\n<ul>\n<li><a href=\"#using-character-map\"><strong>Using Character Map<\/strong><\/a><\/li>\n<li><a href=\"#using-symbol-menu\"><strong>Using Symbol Menu<\/strong><\/a><\/li>\n<li><a href=\"#using-char-function\"><strong>Using CHAR Function<\/strong><\/a><\/li>\n<li><a href=\"#using-alt-codes\"><strong>Using Alt Codes<\/strong><\/a><strong>\u00a0<\/strong><\/li>\n<\/ul>\n<p>Let&#8217;s look at each one of these methods!<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><a id=\"using-character-map\"><\/a>Using Character Map<\/span><\/h3>\n<p>Watch it on <a href=\"https:\/\/youtu.be\/a-uJ7zJUEQw\" target=\"_blank\" rel=\"nofollow noopener\"><strong>YouTube<\/strong><\/a> and give it a thumbs-up!<\/p>\n<div class=\"after-post-box\"><iframe src=\"https:\/\/www.youtube.com\/embed\/a-uJ7zJUEQw?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle;\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/div>\n<p>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:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/01\/How-to-Use-Wingdings.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">How-to-Use-Wingdings.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong> <\/span><strong>Select\u00a0the cells<\/strong> that you want to place the symbols in:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-74.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22449\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-74.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"664\" height=\"318\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-74.png 664w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-74-300x144.png 300w\" sizes=\"(max-width: 664px) 100vw, 664px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Go to <strong>Home<\/strong> Tab &gt; <strong>Font dropdown &gt; <\/strong>Select <strong>Wingdings<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-2.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone wp-image-6273 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-2.jpg\" alt=\"How to Use Wingdings Characters in Excel\" width=\"479\" height=\"392\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-2.jpg 479w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-2-300x246.jpg 300w\" sizes=\"(max-width: 479px) 100vw, 479px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> Now that our cells are able to accept Wingdings characters, go to <strong><a class=\"wpil_keyword_link\" href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/download-office\" target=\"_blank\" rel=\"noopener nofollow\" title=\"Windows\" data-wpil-keyword-link=\"linked\">Windows<\/a> Start (Windows 10) <\/strong><strong>&gt; Search Bar\u00a0&gt; Character Map<\/strong><\/p>\n<p>If you have an older version of Windows, go to\u00a0<strong>Start &gt; All Programs &gt; Accessories &gt; System Tools &gt; Character Map<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-3.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-6274\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-3.jpg\" alt=\"How to Use Wingdings Characters in Excel\" width=\"391\" height=\"629\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-3.jpg 391w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-3-186x300.jpg 186w\" sizes=\"(max-width: 391px) 100vw, 391px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> You will now see all the characters in the wingdings chart!\u00a0 Ensure the <strong>Font\u00a0<\/strong>is\u00a0<strong>Wingdings.<\/strong><\/p>\n<p>Double click on the symbol you want to use. Click <strong>Copy.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-4.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-6275\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-4.jpg\" alt=\"How to Use Wingdings Characters in Excel\" width=\"476\" height=\"413\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-4.jpg 476w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-4-300x260.jpg 300w\" sizes=\"(max-width: 476px) 100vw, 476px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span>\u00a0Go to your Excel <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" title=\"Spreadsheet\" data-wpil-keyword-link=\"linked\">Spreadsheet<\/a> and click\u00a0<strong>Paste<\/strong><strong>.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-5.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-6276\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-5.jpg\" alt=\"How to Use Wingdings Characters in Excel\" width=\"383\" height=\"280\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-5.jpg 383w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-5-300x219.jpg 300w\" sizes=\"(max-width: 383px) 100vw, 383px\" \/><\/a><\/p>\n<p>Do the rest for the other cells, and you have used <strong>Wingdings Symbols!<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-6.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-6277\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-6.jpg\" alt=\"How to Use Wingdings Characters in Excel\" width=\"386\" height=\"117\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-6.jpg 386w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/04\/How-to-Use-Wingdings-6-300x91.jpg 300w\" sizes=\"(max-width: 386px) 100vw, 386px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><a id=\"using-symbol-menu\"><\/a>Using Symbol Menu<\/span><\/h3>\n<p>You can use the insert symbols option to use Windings characters in Excel.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Select the cells where you want to insert symbols.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-74.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22449\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-74.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"664\" height=\"318\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-74.png 664w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-74-300x144.png 300w\" sizes=\"(max-width: 664px) 100vw, 664px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Go to <strong>Insert<\/strong> Tab&gt; <strong>Symbols dropdown<\/strong> &gt; Select <strong>Symbol<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-69.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22442\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-69.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"1351\" height=\"273\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-69.png 1351w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-69-300x61.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-69-1024x207.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-69-768x155.png 768w\" sizes=\"(max-width: 1351px) 100vw, 1351px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> In the Symbols dialog box, select <strong>Windings<\/strong> from the <strong>font dropdown<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-70.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22443\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-70.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"560\" height=\"408\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-70.png 560w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-70-300x219.png 300w\" sizes=\"(max-width: 560px) 100vw, 560px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> Select the<strong> arrow up<\/strong> symbol from the wingdings font chart and press <strong>Insert<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-71.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22444\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-71.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"560\" height=\"408\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-71.png 560w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-71-300x219.png 300w\" sizes=\"(max-width: 560px) 100vw, 560px\" \/><\/a><\/p>\n<p>The arrow symbol will now be inserted in the cell.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-73.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22445\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-73.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"630\" height=\"373\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-73.png 630w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-73-300x178.png 300w\" sizes=\"(max-width: 630px) 100vw, 630px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> <strong>Repeat the same steps<\/strong> for inserting the symbols in cell D7 and D8.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-72.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22446\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-72.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"660\" height=\"378\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-72.png 660w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-72-300x172.png 300w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><a id=\"using-char-function\"><\/a>Using CHAR Function<\/span><\/h3>\n<p>In the previous method, you might have noticed that for every wingdings symbols there is a <strong>character\u00a0code mentioned in the bottom right corner<\/strong> of the Symbol dialog box.<\/p>\n<p><strong>For example &#8211;<\/strong> The character code for the upwards arrow is 233.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-75.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22455\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-75.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"561\" height=\"407\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-75.png 561w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-75-300x218.png 300w\" sizes=\"(max-width: 561px) 100vw, 561px\" \/><\/a><\/p>\n<p>You can use the<strong> CHAR Function in Excel<\/strong> to insert the character code and return the corresponding symbol.<\/p>\n<p>CHAR function returns a<strong>\u00a0character specified by a number<\/strong>\u00a0from 1 to 255. For example, CHAR(254) returns a tick box (&#x2611;), CHAR(34) returns a \u201d (double quote), CHAR(233) returns \u2191(arrow upwards), etc.<\/p>\n<p>In the example below, there is a <strong>list of Order IDs<\/strong> and you want to add a tick box for the orders that have been dispatched.<\/p>\n<p>Let&#8217;s use this CHAR function to insert a tick box in Excel!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-77.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22456\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-77.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"647\" height=\"476\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-77.png 647w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-77-300x221.png 300w\" sizes=\"(max-width: 647px) 100vw, 647px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Select the cell where you want to insert a tick box.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-78.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22457\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-78.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"340\" height=\"329\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-78.png 340w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-78-300x290.png 300w\" sizes=\"(max-width: 340px) 100vw, 340px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Enter the<strong> CHAR<\/strong> Function.<\/p>\n<h3><span style=\"color: #339966;\">=CHAR(<\/span><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-79.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22458\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-79.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"396\" height=\"368\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-79.png 396w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-79-300x279.png 300w\" sizes=\"(max-width: 396px) 100vw, 396px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> Enter the <strong>character code<\/strong> of the tick box and <strong>press Enter<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-81.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22460\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-81.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"398\" height=\"388\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-81.png 398w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-81-300x292.png 300w\" sizes=\"(max-width: 398px) 100vw, 398px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 4:<\/strong><\/span> Go to <strong>Home<\/strong> &gt; <strong>Font Dropdown<\/strong> &gt; Select <strong>Wingdings<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-82.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22461\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-82.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"549\" height=\"621\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-82.png 549w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-82-265x300.png 265w\" sizes=\"(max-width: 549px) 100vw, 549px\" \/><\/a><\/p>\n<p>This will insert the tick box symbol in the selected cell!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-83.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22462\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-83.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"336\" height=\"327\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-83.png 336w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-83-300x292.png 300w\" sizes=\"(max-width: 336px) 100vw, 336px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 5:<\/strong><\/span> <strong>Copy-paste the <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a><\/strong> in the cells where you want a tick box.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-84.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22463\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-84.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"335\" height=\"323\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-84.png 335w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-84-300x289.png 300w\" sizes=\"(max-width: 335px) 100vw, 335px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #008000;\"><a id=\"using-alt-codes\"><\/a>Using Alt Codes<\/span><\/h3>\n<p>An easier way to insert character in Excel is to <strong>use the Alt button in a combination with the character code<\/strong>.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 1:<\/strong><\/span> Select the cell where you want to insert a symbol.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-78.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22457\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-78.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"340\" height=\"329\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-78.png 340w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-78-300x290.png 300w\" sizes=\"(max-width: 340px) 100vw, 340px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 2:<\/strong><\/span> Go to <strong>Home<\/strong> &gt; <strong>Font Dropdown<\/strong> &gt; Select <strong>Wingdings<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-82.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22461\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-82.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"549\" height=\"621\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-82.png 549w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-82-265x300.png 265w\" sizes=\"(max-width: 549px) 100vw, 549px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000;\"><strong>STEP 3:<\/strong><\/span> <strong>Press and hold the Alt<\/strong> button and then <strong>type the character code<\/strong> <strong>(0254)<\/strong> on your keypad.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-86.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to Use Wingdings Characters in Excel\"  class=\"alignnone size-full wp-image-22464\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-86.png\" alt=\"How to Use Wingdings Characters in Excel\" width=\"363\" height=\"368\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-86.png 363w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/05\/Screenshot-86-296x300.png 296w\" sizes=\"(max-width: 363px) 100vw, 363px\" \/><\/a><\/p>\n<p>This is how you can easily<strong> use the Alt button<\/strong> to insert windings characters in Excel. But, you need to <strong>keep the following points in mind<\/strong> while using this method:<\/p>\n<ul>\n<li>You have to <strong>add a leading zero<\/strong> in front of the character code i.e. you need to type 0254, not 254.<\/li>\n<li>You need to use the <strong>numerical keypad,<\/strong> not the numbers at the top of the keyboard.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\">Conclusion<\/span><\/h3>\n<p>To insert Wingdings Characters in Excel, you can use the<strong> character map<\/strong>, the <strong>symbol menu<\/strong>, the <strong>CHAR function,<\/strong> or the <strong>ALT<\/strong> button.<\/p>\n<p>Either of these methods will get the job done for you!<\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-custom-symbols-with-your-numbers-in-excel\/\" target=\"_blank\" rel=\"noopener\">Create Custom Symbols in Excel based on Numbers<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-a-degree-symbol-to-selection-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener\">Add a Degree Symbol to Selection Using Macros In Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/special-characters-in-excel\/\" target=\"_blank\" rel=\"noopener\">Top 3 Methods to Find Special Characters in Excel<\/a><\/li>\n<\/ul>\n<p><strong>Make sure to download our FREE PDF on the<a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-5924 size-full aligncenter\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg\" sizes=\"(max-width: 530px) 100vw, 530px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/03\/530x300-Pivot-300x170.jpg 300w\" width=\"530\" height=\"300\" alt=\"\" title=\"\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17267,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,7,10,41],"tags":[251,250],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6270"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=6270"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/6270\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17267"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=6270"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=6270"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=6270"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}