Excel - Emoji & Symbols

---

We are all aware of emojis that describe the emotions of the users. You can add the different types of emojis in Microsoft Excel through the Icons button presented in the Illustrations group. These graphics, like Emojis, can be customized to make them more stunning and appealing.

Additionally, the Symbols feature allows you to add different categories of symbols, including currency, mathematical notation, delta, and degree symbols. This is especially useful for adding symbols that are unavailable on the keyboards. Depending on ASCII codes, you may also utilize the Char() function to add symbols.

Compatibility

You can insert the symbols in the following version of Microsoft Excel −

• Excel for Microsoft 365
• Excel 2024
• Excel 2021
• Excel 2019
• Excel 2016
• Excel for Mac
• Excel Online

Insert Emoji in Microsoft Excel

Various steps to add Emojis are given below −

Step 1 − Deliberate a worksheet, go to the "Insert" tab, expand the "Illustrations" tile, and select the "Icons" from the list.

Another window, "Stock Images," will open. Type "emoji" in the textbox and select the "Outline" emoji. Then, hit the Insert button.

Therefore, a happy emoji has been inserted into the Microsoft Excel. You may increase/decrease its size.

Emoji Formatting in Microsoft Excel

You can select the Emoji graphic and the "Graphics Format" tab. Expand the "Graphics Outline" option and choose green from the theme color list.

Therefore, the Emoji Graphics outline has been changed to green.

Insert Degree Symbol in Microsoft Excel

The keyboard shortcut to insert the degree symbol in Excel is −

=CHAR(176)

For instance, double-click on the specific cell, type =CHAR(176) and hit Enter.

Therefore, the degree symbol is inserted in the Excel.

Lets say you have a list of Delhi temperatures in the C column and wish to insert the degree symbols of the temperatures in Excel.

Select the C4 cell and navigate to the Insert tab, select the "Symbols" tile, and choose the "Symbol" option.

After that, another dialog box, Symbol, will open, where you can select a degree symbol and press Insert.

Therefore, the degree symbol is inserted in the C4 cell. To embed the degree symbol, repeat the same step for the remaining cell range, "C5:C8."

Therefore, the degree symbols are inserted, specifying different temperatures in Excel.

Insert Symbols in Microsoft Excel

Step 1 − Move to the Insert tab, expand the "Symbols" tile, and select the "Symbol" option.

Step 2 − Another dialog box, "Symbol," will appear. Two tabs, "Symbols" and "Special Characters," are available. You can select the font type from the drop-down menu in the Font: section. For instance, select the "Yen" sign in the "Recently used symbols:" and press the Insert button five times.

Note − You can select only one symbol once.

Hence, the Yen sign symbols are placed in the B2 cell.