Do you know that you can add emojis to your charts, slicers, and worksheet names in Excel?

What are emojis?

Emojis, everyone knows what is it. There are small icons that we insert in a message to express

• Your feelings: 🙂(happy) 😍 (love) 😎 (cool) 😲 (wow) 😱 (scary) 😡 (angry)
• Events: like Christmas🎄 , Victory🏆, Wedding 👰
• Objects: ☎ 🔒 🚗 📸 🍺

Since Excel 2010, emojis can be added to your worksheets as names, used in formulas, charts, or slicers

How to insert emojis in Excel?

There are 2 ways to add emojis to your worksheets

1 Windows Shortcut

1. Open the emoji's dialog box with the shortcut Win key + ; (semi-colon)
2. Then, select the icon you want to add.

2 Virtual keyboard

1. Start by opening the virtual keyboard on the taskbar. (If the icon is not visible, right-click on the bar and check the option for the Show Touch Keyboard button)

2. In the virtual keyboard, click on the heart at the upper-left corner of the virtual keyboard

3. Open the emoji menu

4. Select one of the emojis in the menu

Add other icons

But not all the emojis are listed in these two dialog boxes, like this icon.

Each icon has a hexadecimal code, like 1F515 to display a silence mode. The full list of this code is on this page.

You can return each emoji in Excel with the following formula:

=UNICHAR(HEX2DEC("1F515"))

• HEX2DEC will convert the hexadecimal code to decimal
• UNICHAR will turn this decimal code into emojis
• You must write the code between double quotes

And then you convert this formula with a copy-paste value.

Icon in color

• If you add icon in Excel desktop, the icon will be black and white
• But with a Mac or Excel Online, the icon will be in color

How icons could be used in Excel?

As worksheet name

You can also use icons as Worksheet name

In formula

Also, in a formula. In the following example, the prices of rooms are identified by emojis. The VLOOKUP function returns the result according to each icon.

In Charts

You can use emojis as chart labels. The icons are in color with Excel Desktop 😀👍

Or as a data labels

In Slicers

Or you can add emojis in your Excel document to use them as a slicer.