Today, we will learn how to put emo­jis into Excel. We will have a look at three solutions. 

How to insert Emo­jis in Excel

The first one is just copy­ing emo­jis from the inter­net into Excel in the edit mode and past­ing it. If the emo­ji we past­ed is too large for a cell, we have to change the font into small­er (Fig. 67)

Emoji's size modification
Fig. 1 Emo­ji’s size modification

The sec­ond solu­tion involves insert­ing sym­bols by using the Sym­bol icon (1) and choos­ing the emo­ji you want (2). Then press the Insert but­ton (3) and that’s it (Fig. 2)

Inserting emojis from symbols
Fig. 2 Insert­ing emo­jis from symbols

The third solu­tion is using the Touch key­board (Fig. 3 and Fig. 4)

Touch keyboard button location
Fig. 3 Touch key­board but­ton location
Exact location
Fig. 4 Exact location

You have to press the Emo­ji key, (Fig. 5)

Emoji key
Fig. 5 Emo­ji key

…and choose emo­jis you want (Fig. 6)

Chosen emojis
Fig. 6 Cho­sen emojis

When we have our emo­jis in Excel, we can use them in for­mu­las. Some­times such a for­mu­la will look dif­fer­ent­ly than in a cell (Fig. 7)

A formula with emojis
Fig. 7 A for­mu­la with emojis

One last thing. In Excel online, emo­jis are more col­or­ful 🙂 (Fig. 8)

Colored emojis
Fig. 8 Col­ored emojis

https://www.youtube.com/watch?v=gja6eVWxnx4