Dingbats are a symbol that can add visual interest to your Google Sheets spreadsheets. You can insert dingbats into Google Sheets using one of three methods. Use the method that works best in your spreadsheet.
Use the CHAR Function
Find the Unicode decimal code for the dingbat in the table at the end of this article, and insert it using the CHAR function. For example, =CHAR(9985) inserts “Upper Blade Scissors.”
Copy and Paste
You can find the symbols you want in the table below, copy the dingbats, and paste them into your spreadsheet.
Use an Add-On
The Insert Special Characters add-on is the easiest way to insert special characters. Browse through all the Dingbats and choose the symbol you want. Then insert the symbol with just one click.
All Dingbat Characters with Unicode Decimal Codes
| Decimal | Name | Appearance |
|---|---|---|
| 9985 | UPPER BLADE SCISSORS | ✁ |
| 9986 | BLACK SCISSORS | ✂ |
| 9987 | LOWER BLADE SCISSORS | ✃ |
| 9988 | WHITE SCISSORS | ✄ |
| 9990 | TELEPHONE LOCATION SIGN | ✆ |
| 9991 | TAPE DRIVE | ✇ |
| 9992 | AIRPLANE | ✈ |
| 9993 | ENVELOPE | ✉ |
| 9996 | VICTORY HAND | ✌ |
| 9997 | WRITING HAND | ✍ |
| 9998 | LOWER RIGHT PENCIL | ✎ |
| 9999 | PENCIL | ✏ |
| 10000 | UPPER RIGHT PENCIL | ✐ |
| 10001 | WHITE NIB | ✑ |
| 10002 | BLACK NIB | ✒ |
| 10003 | CHECK MARK | ✓ |
| 10004 | HEAVY CHECK MARK | ✔ |
| 10005 | MULTIPLICATION X | ✕ |
| 10006 | HEAVY MULTIPLICATION X | ✖ |
| 10007 | BALLOT X | ✗ |
| 10008 | HEAVY BALLOT X | ✘ |
| 10009 | OUTLINED GREEK CROSS | ✙ |
| 10010 | HEAVY GREEK CROSS | ✚ |
| 10011 | OPEN CENTRE CROSS | ✛ |
| 10012 | HEAVY OPEN CENTRE CROSS | ✜ |
| 10013 | LATIN CROSS | ✝ |
| 10014 | SHADOWED WHITE LATIN CROSS | ✞ |
| 10015 | OUTLINED LATIN CROSS | ✟ |
| 10016 | MALTESE CROSS | ✠ |
| 10017 | STAR OF DAVID | ✡ |
| 10018 | FOUR TEARDROP-SPOKED ASTERISK | ✢ |
| 10019 | FOUR BALLOON-SPOKED ASTERISK | ✣ |
| 10020 | HEAVY FOUR BALLOON-SPOKED ASTERISK | ✤ |
| 10021 | FOUR CLUB-SPOKED ASTERISK | ✥ |
| 10022 | BLACK FOUR POINTED STAR | ✦ |
| 10023 | WHITE FOUR POINTED STAR | ✧ |
| 10025 | STRESS OUTLINED WHITE STAR | ✩ |
| 10026 | CIRCLED WHITE STAR | ✪ |
| 10027 | OPEN CENTRE BLACK STAR | ✫ |
| 10028 | BLACK CENTRE WHITE STAR | ✬ |
| 10029 | OUTLINED BLACK STAR | ✭ |
| 10030 | HEAVY OUTLINED BLACK STAR | ✮ |
| 10031 | PINWHEEL STAR | ✯ |
| 10032 | SHADOWED WHITE STAR | ✰ |
| 10033 | HEAVY ASTERISK | ✱ |
| 10034 | OPEN CENTRE ASTERISK | ✲ |
| 10035 | EIGHT SPOKED ASTERISK | ✳ |
| 10036 | EIGHT POINTED BLACK STAR | ✴ |
| 10037 | EIGHT POINTED PINWHEEL STAR | ✵ |
| 10038 | SIX POINTED BLACK STAR | ✶ |
| 10039 | EIGHT POINTED RECTILINEAR BLACK STAR | ✷ |
| 10040 | HEAVY EIGHT POINTED RECTILINEAR BLACK STAR | ✸ |
| 10041 | TWELVE POINTED BLACK STAR | ✹ |
| 10042 | SIXTEEN POINTED ASTERISK | ✺ |
| 10043 | TEARDROP-SPOKED ASTERISK | ✻ |
| 10044 | OPEN CENTRE TEARDROP-SPOKED ASTERISK | ✼ |
| 10045 | HEAVY TEARDROP-SPOKED ASTERISK | ✽ |
| 10046 | SIX PETALLED BLACK AND WHITE FLORETTE | ✾ |
| 10047 | BLACK FLORETTE | ✿ |
| 10048 | WHITE FLORETTE | ❀ |
| 10049 | EIGHT PETALLED OUTLINED BLACK FLORETTE | ❁ |
| 10050 | CIRCLED OPEN CENTRE EIGHT POINTED STAR | ❂ |
| 10051 | HEAVY TEARDROP-SPOKED PINWHEEL ASTERISK | ❃ |
| 10052 | SNOWFLAKE | ❄ |
| 10053 | TIGHT TRIFOLIATE SNOWFLAKE | ❅ |
| 10054 | HEAVY CHEVRON SNOWFLAKE | ❆ |
| 10055 | SPARKLE | ❇ |
| 10056 | HEAVY SPARKLE | ❈ |
| 10057 | BALLOON-SPOKED ASTERISK | ❉ |
| 10058 | EIGHT TEARDROP-SPOKED PROPELLER ASTERISK | ❊ |
| 10059 | HEAVY EIGHT TEARDROP-SPOKED PROPELLER ASTERISK | ❋ |
| 10061 | SHADOWED WHITE CIRCLE | ❍ |
| 10063 | LOWER RIGHT DROP-SHADOWED WHITE SQUARE | ❏ |
| 10064 | UPPER RIGHT DROP-SHADOWED WHITE SQUARE | ❐ |
| 10065 | LOWER RIGHT SHADOWED WHITE SQUARE | ❑ |
| 10066 | UPPER RIGHT SHADOWED WHITE SQUARE | ❒ |
| 10070 | BLACK DIAMOND MINUS WHITE X | ❖ |
| 10072 | LIGHT VERTICAL BAR | ❘ |
| 10073 | MEDIUM VERTICAL BAR | ❙ |
| 10074 | HEAVY VERTICAL BAR | ❚ |
| 10075 | HEAVY SINGLE TURNED COMMA QUOTATION MARK ORNAMENT | ❛ |
| 10076 | HEAVY SINGLE COMMA QUOTATION MARK ORNAMENT | ❜ |
| 10077 | HEAVY DOUBLE TURNED COMMA QUOTATION MARK ORNAMENT | ❝ |
| 10078 | HEAVY DOUBLE COMMA QUOTATION MARK ORNAMENT | ❞ |
| 10081 | CURVED STEM PARAGRAPH SIGN ORNAMENT | ❡ |
| 10082 | HEAVY EXCLAMATION MARK ORNAMENT | ❢ |
| 10083 | HEAVY HEART EXCLAMATION MARK ORNAMENT | ❣ |
| 10084 | HEAVY BLACK HEART | ❤ |
| 10085 | ROTATED HEAVY BLACK HEART BULLET | ❥ |
| 10086 | FLORAL HEART | ❦ |
| 10087 | ROTATED FLORAL HEART BULLET | ❧ |
| 10102 | DINGBAT NEGATIVE CIRCLED DIGIT ONE | ❶ |
| 10103 | DINGBAT NEGATIVE CIRCLED DIGIT TWO | ❷ |
| 10104 | DINGBAT NEGATIVE CIRCLED DIGIT THREE | ❸ |
| 10105 | DINGBAT NEGATIVE CIRCLED DIGIT FOUR | ❹ |
| 10106 | DINGBAT NEGATIVE CIRCLED DIGIT FIVE | ❺ |
| 10107 | DINGBAT NEGATIVE CIRCLED DIGIT SIX | ❻ |
| 10108 | DINGBAT NEGATIVE CIRCLED DIGIT SEVEN | ❼ |
| 10109 | DINGBAT NEGATIVE CIRCLED DIGIT EIGHT | ❽ |
| 10110 | DINGBAT NEGATIVE CIRCLED DIGIT NINE | ❾ |
| 10111 | DINGBAT NEGATIVE CIRCLED NUMBER TEN | ❿ |
| 10112 | DINGBAT CIRCLED SANS-SERIF DIGIT ONE | ➀ |
| 10113 | DINGBAT CIRCLED SANS-SERIF DIGIT TWO | ➁ |
| 10114 | DINGBAT CIRCLED SANS-SERIF DIGIT THREE | ➂ |
| 10115 | DINGBAT CIRCLED SANS-SERIF DIGIT FOUR | ➃ |
| 10116 | DINGBAT CIRCLED SANS-SERIF DIGIT FIVE | ➄ |
| 10117 | DINGBAT CIRCLED SANS-SERIF DIGIT SIX | ➅ |
| 10118 | DINGBAT CIRCLED SANS-SERIF DIGIT SEVEN | ➆ |
| 10119 | DINGBAT CIRCLED SANS-SERIF DIGIT EIGHT | ➇ |
| 10120 | DINGBAT CIRCLED SANS-SERIF DIGIT NINE | ➈ |
| 10121 | DINGBAT CIRCLED SANS-SERIF NUMBER TEN | ➉ |
| 10122 | DINGBAT NEGATIVE CIRCLED SANS-SERIF DIGIT ONE | ➊ |
| 10123 | DINGBAT NEGATIVE CIRCLED SANS-SERIF DIGIT TWO | ➋ |
| 10124 | DINGBAT NEGATIVE CIRCLED SANS-SERIF DIGIT THREE | ➌ |
| 10125 | DINGBAT NEGATIVE CIRCLED SANS-SERIF DIGIT FOUR | ➍ |
| 10126 | DINGBAT NEGATIVE CIRCLED SANS-SERIF DIGIT FIVE | ➎ |
| 10127 | DINGBAT NEGATIVE CIRCLED SANS-SERIF DIGIT SIX | ➏ |
| 10128 | DINGBAT NEGATIVE CIRCLED SANS-SERIF DIGIT SEVEN | ➐ |
| 10129 | DINGBAT NEGATIVE CIRCLED SANS-SERIF DIGIT EIGHT | ➑ |
| 10130 | DINGBAT NEGATIVE CIRCLED SANS-SERIF DIGIT NINE | ➒ |
| 10131 | DINGBAT NEGATIVE CIRCLED SANS-SERIF NUMBER TEN | ➓ |
| 10132 | HEAVY WIDE-HEADED RIGHTWARDS ARROW | ➔ |
| 10136 | HEAVY SOUTH EAST ARROW | ➘ |
| 10137 | HEAVY RIGHTWARDS ARROW | ➙ |
| 10138 | HEAVY NORTH EAST ARROW | ➚ |
| 10139 | DRAFTING POINT RIGHTWARDS ARROW | ➛ |
| 10140 | HEAVY ROUND-TIPPED RIGHTWARDS ARROW | ➜ |
| 10141 | TRIANGLE-HEADED RIGHTWARDS ARROW | ➝ |
| 10142 | HEAVY TRIANGLE-HEADED RIGHTWARDS ARROW | ➞ |
| 10143 | DASHED TRIANGLE-HEADED RIGHTWARDS ARROW | ➟ |
| 10144 | HEAVY DASHED TRIANGLE-HEADED RIGHTWARDS ARROW | ➠ |
| 10145 | BLACK RIGHTWARDS ARROW | ➡ |
| 10146 | THREE-D TOP-LIGHTED RIGHTWARDS ARROWHEAD | ➢ |
| 10147 | THREE-D BOTTOM-LIGHTED RIGHTWARDS ARROWHEAD | ➣ |
| 10148 | BLACK RIGHTWARDS ARROWHEAD | ➤ |
| 10149 | HEAVY BLACK CURVED DOWNWARDS AND RIGHTWARDS ARROW | ➥ |
| 10150 | HEAVY BLACK CURVED UPWARDS AND RIGHTWARDS ARROW | ➦ |
| 10151 | SQUAT BLACK RIGHTWARDS ARROW | ➧ |
| 10152 | HEAVY CONCAVE-POINTED BLACK RIGHTWARDS ARROW | ➨ |
| 10153 | RIGHT-SHADED WHITE RIGHTWARDS ARROW | ➩ |
| 10154 | LEFT-SHADED WHITE RIGHTWARDS ARROW | ➪ |
| 10155 | BACK-TILTED SHADOWED WHITE RIGHTWARDS ARROW | ➫ |
| 10156 | FRONT-TILTED SHADOWED WHITE RIGHTWARDS ARROW | ➬ |
| 10157 | HEAVY LOWER RIGHT-SHADOWED WHITE RIGHTWARDS ARROW | ➭ |
| 10158 | HEAVY UPPER RIGHT-SHADOWED WHITE RIGHTWARDS ARROW | ➮ |
| 10159 | NOTCHED LOWER RIGHT-SHADOWED WHITE RIGHTWARDS ARROW | ➯ |
| 10161 | NOTCHED UPPER RIGHT-SHADOWED WHITE RIGHTWARDS ARROW | ➱ |
| 10162 | CIRCLED HEAVY WHITE RIGHTWARDS ARROW | ➲ |
| 10163 | WHITE-FEATHERED RIGHTWARDS ARROW | ➳ |
| 10164 | BLACK-FEATHERED SOUTH EAST ARROW | ➴ |
| 10165 | BLACK-FEATHERED RIGHTWARDS ARROW | ➵ |
| 10166 | BLACK-FEATHERED NORTH EAST ARROW | ➶ |
| 10167 | HEAVY BLACK-FEATHERED SOUTH EAST ARROW | ➷ |
| 10168 | HEAVY BLACK-FEATHERED RIGHTWARDS ARROW | ➸ |
| 10169 | HEAVY BLACK-FEATHERED NORTH EAST ARROW | ➹ |
| 10170 | TEARDROP-BARBED RIGHTWARDS ARROW | ➺ |
| 10171 | HEAVY TEARDROP-SHANKED RIGHTWARDS ARROW | ➻ |
| 10172 | WEDGE-TAILED RIGHTWARDS ARROW | ➼ |
| 10173 | HEAVY WEDGE-TAILED RIGHTWARDS ARROW | ➽ |
| 10174 | OPEN-OUTLINED RIGHTWARDS ARROW | ➾ |
| 10175 | DOUBLE CURLY LOOP | ➿ |