How to insert emoji or emoticon in Excel formulas with keyboard?

Who I am
Marie-Ange Demory
Author and references

Actually this idea that Microsoft has added to its latest releases has been implemented and is becoming more common than it seems.

So, if you want your spreadsheets to be more extroverted and catchy, keep reading this article to learn how to insert them.

Use your keyboard to insert emojis into Excel formulas

Adding these symbols to your keyboard will help you get started insert emoticons in Excel sheets, even if they are not usually displayed on the physical keyboard.

That's why, based on the versions of Windows released by Microsoft, you will find a way to view them. Creating custom emojis for Android and iOS is easy, the difficult thing is to relate them to Excel.

The use of this type of symbology will depend on how you want it to express the results or be part of the formula.

To add them, there are multiple methods that are directly related to the version you are using, via the physical keyboard, the on-screen keyboard, via the numeric keypad, or by copying and pasting it into your spreadsheet.

In the formula bar you will take care of transcribing the formula you want to make, and that's where you will choose whether to use the Emoji to change the view of the sheet.

It is important to point out that the symbols must go inside the quotation marks in each function that is established, in the same way as with lyrics.

A formula that can serve as a example is the following, where the question marks will be replaced by the Emoji of your choice:

  • = SE (F3> 1; “??”; ”??»)

Ways to add emoticons depending on the version of Windows you have

Whether to insert Emojis in Excel or any other Windows task, you need the keyboard to show the option to be able to add them.

Windows 7

As of the dates this version was released, there was not yet quick access to this font style on any keyboard type.

So, if you want to review the Emoji list to select which one you want to add to the sheet you develop in Excel, you need to do the following steps:

By pressing the key » Start »The basic Windows menu will be displayed and in the search engine you will have to type» Character map »To open a window.

Among the sources you will look for the one called " Segoe UI Symbol »And it is by browsing that section where you will find the Emoji available on the computer to use.

It is necessary to press the left mouse button twice on the symbols so that they are displayed in the name bar " Characters to copy «, Then press» Select »To copy and paste it into Excel.

Touch keyboard or screen

Starting with version 8.1, Windows has allowed you to activate one section for symbols on the onscreen keyboard, which works to insert Emoji into Excel formulas.

You will be able to access it via the system tray which can be displayed at the bottom of the screen with a keyboard icon that you simply need to press.

There you will see a symbol of a happy face on the left side of the space bar where you will find one collection with all these characters.

Windows 10

One benefit this version offers for user interaction is to create the collegamento to show emoticons using a combination of keys.

To do this, press " Windows+. ”To bring up a small window that will contain the same collection of Emojis that are shown on the keyboards of mobile devices.

Audio Video How to insert emoji or emoticon in Excel formulas with keyboard?
add a comment of How to insert emoji or emoticon in Excel formulas with keyboard?
Comment sent successfully! We will review it in the next few hours.