Add Emojis to your Excel charts, formulas

Add Emojis to your Excel charts, formulas
Last Updated on 02/10/2023
Reading time: 3 minutes

Do you know that you can add emojis in 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)

More, we can express events like Christmas🎄 , Victory🏆, Wedding 👰and also Objects ☎ 🔒 🚗 📸 🍺

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

Chart label are icons

How to insert emojis in Excel?

There are 2 ways to add emojis to your worksheets

1 Shortcuts

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

2 Virtual keyboard

1. Start by opening the virtual keyboard on the task bar. If the icon is not visible, Right-Click on the bar and check the option Show Touch Keyboard Button.

Menu to open the virtual keyboard

2. In the virtual keyboard, open the icons set.

Virtual Keyboard with Windows 10

3. Choose the emojis you want to insert.

Set of Emojis

Add other icons

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

Each icon has is own hexadecimal code (like 1F515 to display a silence mode). You can find the full list of this code on this page. Now in Excel, to insert an emoticon from its hexadecimal code, we will use 2 functions

  • HEX2DEC will convert the hexadecimal code to decimal
  • UNICHAR will turn this decimal code into emojis

=UNICHAR(HEX2DEC("1F515"))

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

Emoji 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 emoji as chart label.

Chart label are icons

In Slicers

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

3 Comments

  1. It consultancy Australia
    11/11/2022 @ 09:40

    Thank you so much for this article! This was exactly what I needed.

    Reply

  2. Tawanna
    10/01/2020 @ 19:59

    This website was... how ddo you say it? Relevant!!
    Finally I have found something that helpd me.
    Kudos!

    Reply

    • Frédéric LE GUEN
      10/01/2020 @ 20:56

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Add Emojis to your Excel charts, formulas

Reading time: 3 minutes
Last Updated on 02/10/2023

Do you know that you can add emojis in 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)

More, we can express events like Christmas🎄 , Victory🏆, Wedding 👰and also Objects ☎ 🔒 🚗 📸 🍺

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

Chart label are icons

How to insert emojis in Excel?

There are 2 ways to add emojis to your worksheets

1 Shortcuts

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

2 Virtual keyboard

1. Start by opening the virtual keyboard on the task bar. If the icon is not visible, Right-Click on the bar and check the option Show Touch Keyboard Button.

Menu to open the virtual keyboard

2. In the virtual keyboard, open the icons set.

Virtual Keyboard with Windows 10

3. Choose the emojis you want to insert.

Set of Emojis

Add other icons

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

Each icon has is own hexadecimal code (like 1F515 to display a silence mode). You can find the full list of this code on this page. Now in Excel, to insert an emoticon from its hexadecimal code, we will use 2 functions

  • HEX2DEC will convert the hexadecimal code to decimal
  • UNICHAR will turn this decimal code into emojis

=UNICHAR(HEX2DEC("1F515"))

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

Emoji 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 emoji as chart label.

Chart label are icons

In Slicers

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

3 Comments

  1. It consultancy Australia
    11/11/2022 @ 09:40

    Thank you so much for this article! This was exactly what I needed.

    Reply

  2. Tawanna
    10/01/2020 @ 19:59

    This website was... how ddo you say it? Relevant!!
    Finally I have found something that helpd me.
    Kudos!

    Reply

    • Frédéric LE GUEN
      10/01/2020 @ 20:56

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *