We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)
Just because it’s a spreadsheet doesn’t mean you can’t use emojis in Excel! Emojis can help you add personality to your spreadsheets and a fun visual to better communicate your message.
You can even use emojis with some Excel formulas!
Here are 4 ways to insert emojis in Excel
1. Use the Emoji Picker
Your computer likely has an emoji picker built-in. It’s super easy to use.
First, open your emoji picker:
- Windows 10 users, press the Windows key + . OR the Windows key + ;
- Mac users, press Control + Command + Space Bar
Next, select your desired emoji.
Press Enter. Press Enter again to insert the emoji multiple times.
Exit out of the emoji picker.
2. Insert Emojis From Symbols
You can insert different emojis from the Symbol options.
You’ll find the Symbol options under the Insert tab, in the Symbols section.
Click to open the Symbols options.
From the Fonts, select Wingdings. FYI, Wingdings2 also has some emoji-like symbols you may want to look at.
Click Insert to insert it in your spreadsheet.
3. Use Alt Keyboard Codes
Alt codes are special symbols, numbers or letters that you can insert by simultaneously pressing the Alt key and a specified number on your keyboard’s number pad.
Note: To use any Alt keyboard shortcuts, it’s important that your keyboard has a number pad. Using the numbers along the top of your keyboard will not work.
Here are some Alt codes you can use for emojis:
4. Insert an Icon Symbol
You’ll find the icons in the Insert tab / Illustrations section / Icons
Simply select the icon you’d like to use and click Insert. You can then recolor and resize your icon symbol like you would any other Shape in Excel.
Using Emojis in Excel Formulas
Now that you know different ways to insert emojis in Excel, you’re probably curious about new ways you can use them to jazz up your spreadsheets.
I got so excited I almost popped and had to share it with you!
FYI, this will work with all of the ways of inserting emojis listed here, EXCEPT for if you use the icon symbols
And, it’s soooo simple! All you need to do is insert the emoji into your formula – making sure to use quotation marks around any emojis.
NOTE: If you’re using Excel Online, you may need to insert the emoji in a different cell, then copy and paste it into your formula.
For example, to return an emoji when using an IF function, you could write something like:
NOTE: In the gif below I’m using Excel on my desktop, but if you’re using the online version, your emojis will be in color.