It is true: the excel spreadsheets They are designed to perform “serious” mathematical operations and calculations. They are a tool that many companies use in their daily lives, although they are also used by individuals who, for example, want to keep track of domestic accounting. This program allows us to create tables, graphs and endless tasks. But it is also possible to give a casual touch to that world of numbers and statistics. In this post we explain how to add emojis to an excel spreadsheet.
At first this may sound a bit shocking. The emojis They are fun symbols that don't seem to fit much with the field of mathematics. However, used well, they can be a complement that adds a new dimension to our spreadsheets.
What can an emoji add to an Excel document? Beyond its role as purely decorative element, emojis are, above all, symbols used for communication.
In fact, they form a kind of visual code that transmits all kinds of messages. And that can be very interesting when we work with spreadsheets, where An emoji can give us the key to interpret the value or meaning of a figure, a table, a graph...
Insert emojis into an Excel spreadsheet: 3 methods
For the task of inserting emojis in Excel we have different methods, all of them very simple. Depending on the type of document we are working with, we can choose to use emojis in color or black and white. These are the options we have:
Method 1: Keyboard shortcut
This is the easiest way to add emojis to an Excel spreadsheet. All we will have to do is click on the cell where we want to insert the emoji and enter the following shortcut: Windows +. With this, a box with all the options will appear on the screen.
It is simply about choose the emoji(s) that we need on each occasion by clicking on them. The box also has an emoji search engine and a file where the symbols that we have used most recently are saved. Very practical.
It must be said that this shortcut also works in the rest of the programs that are part of Microsoft Office.
Method 2: Virtual keyboard
Although not as immediate and direct as the keyboard shortcut method, we can also use the virtual keyboard to insert emojis into our Excel spreadsheets.
To access the virtual keyboard you must click with the right mouse button on the bottom bar of the screen. In the dropdown that opens below, we have to select the “touch keyboard” option. This keyboard has a specific button for emojis. Clicking on it will show all the options. You just have to click on the emoji you want to enter it in the cell you select.
Method 3: From a web page
We still have to explore the external option: resort to the help of a website. There are many on the Internet that collect numerous and varied emojis that we can use free of charge. Most of these sites have an effective search engine to locate the emoji we need. The method couldn't be easier: it's simply a matter of using the old trick of copy and paste.
Although there are many websites of this type, some of the most complete (due to the quantity and quality level of emojis they contain) are Emojipedia o Emojiterra.
How to use emojis in Excel
Well, now we know where to get the emojis that we are going to insert into our Excel spreadsheets. The next thing we need to know is how to do it correctly. That is to say, how to take advantage of the message that each emoji conveys to enrich our document or give it the meaning we want.
We have already seen how emojis can be inserted into cells to complete the cell value. A widely used example is to put the sad face in a cell with a negative value. But there is more:
In the formulas
Although many users ignore it, emojis can be entered in the formulas (as well as in the cells), without this leading to any errors. Obviously, it is necessary to respect the formulation rules and use the appropriate symbols in each case.
In the graphics
And of course, if emojis can be added to replace numerical values, it will also be possible for these to be reflected in the graphs created from the tables. The result will be to offer a different visualization, perhaps more attractive to many observers.
In the page or tab name
Finally, another place where you can insert icons or emojis within the spreadsheet is in the title. For example, if it is an expense sheet, we add the euro bill symbol; If it is a document where we save travel budgets, we can insert the airplane emoji, etc.