Did you know that Emojis have been around since 1997? They essentially became an integral part of written communication methods everywhere. In this article, we are going to show you how to use emojis in Excel.
How to insert an emoji in Excel
You can insert an emoji in any application that has support for them. Word, Notepad or Paint are a few of examples, and conveniently, Excel also has this support. However, the places you can use emojis are a bit more limited in Excel. Let’s take a closer look!
You can open the emojis dialog when you start typing in a cell, a chart title, or a SmartArt label. Press the appropriate key combination depending to your operating system. There are two methods you can use in Windows.
- Win + ;
- Win + .
Command + Control + Space
Virtual (Touch) Keyboard
You may have noticed this before if your computer supports touch keyboards. Due to the lack of a physical keyboard, some key combinations are not available in touch devices. However, there is a dedicated button on your virtual keyboards in Windows. You can find the virtual keyboard in the task bar.
It should come as no surprise that you can add an emoji using Excel formulas. This is possible thanks to the fact that every emoji is encoded as a character in Unicode standard, and has a hexadecimal code. You can use the HEX2DEC and UNICHAR functions to display an emoji if you know its code.
The main function is the UNICHAR which returns a Unicode character of a given numeric value. Since the numeric value should be decimal-based number, any hexadecimal value should be converted into a decimal number. As the name suggests, the HEX2DEC function can help with this conversion.
Here is an example:
Once, you generate the emoji, you can copy and paste it as a value, and use it however you’d like! 🤘
You can access a detailed list of hexadecimal values here: https://en.wikipedia.org/wiki/Emoji.
Where you can use emojis in Excel
To take it one step further, you can also use emojis with pretty much any formula that accepts text data as an argument.
In worksheet names
Although the slicers are commonly used with Pivot Tables, you can use them with Excel Tables as well. If you haven’t tried before, check out this page to learn more: Slicers in Excel Tables
Excel supports emojis in charts as well. You can utilize emojis and symbols to enhance your charts.