Add Emojis to your Excel charts or slicers

Add Emojis to your Excel charts or slicers
Last Updated on 17/04/2024
Reading time: 3 minutes

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

Chart label are icons

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)
Open virtual keyboard windows 11
  1. In the virtual keyboard, click on the heart at the upper-left corner of the virtual keyboard
Open advanced options with the virtual keyboard
  1. Open the emoji menu
Open the virtual emoji menu
  1. Select one of the emojis in the menu
emojis in the Windows virtual keyboard

Add other icons

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

How to add invisble Emojis in Excel

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
Emoji bell for Excel with the hexadecimal code

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
Table of Emojis in Excel

How icons could be used in Excel?

As worksheet name

You can also use icons as Worksheet name

Emojis for Excel 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 😀👍

Chart Series are emojis

Or as a data labels

Chart label are emojis

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 or slicers

Reading time: 3 minutes
Last Updated on 17/04/2024

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

Chart label are icons

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)
Open virtual keyboard windows 11
  1. In the virtual keyboard, click on the heart at the upper-left corner of the virtual keyboard
Open advanced options with the virtual keyboard
  1. Open the emoji menu
Open the virtual emoji menu
  1. Select one of the emojis in the menu
emojis in the Windows virtual keyboard

Add other icons

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

How to add invisble Emojis in Excel

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
Emoji bell for Excel with the hexadecimal code

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
Table of Emojis in Excel

How icons could be used in Excel?

As worksheet name

You can also use icons as Worksheet name

Emojis for Excel 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 😀👍

Chart Series are emojis

Or as a data labels

Chart label are emojis

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 *