How do I insert emojis into Google Sheets?
Do more with your lists. Add some fun emojis in Google Sheets!
Let's say you want to use “1.” in your Sheet when you're numbering a list. It’s really hard to do that. You have to do something like this: ="1."
But you don't want to do that every time. You want to have things in the list. You can just use an emoji instead of "1.", which is really cool. You can also move the user's eyes when you use emojis. You can actually make use of arrows. That way, you can show movement. You can also create a dropdown selection box instead of just using plain text. Sometimes our sheets get really text heavy, but a user could select something like ratings. I think it's really cool and really fun to add star ratings and then be able to turn those stars into numbers so that you can do some calculations. I have a whole other video on that and you can watch it here.
How to insert emojis into Google Sheets
Now let's get started! On a Mac, it’s super simple. Double click into a cell and hit CONTROL + COMMAND + SPACE.
Bam! You get a wonderful little character map.
I really like it because it has the search function. You can search for anything – a stop sign or a no. You can even search by color! So if you want to make sure your entire sheet has the right same color through all your emojis, there you have it.
You can also use a policeman, a blue heart instead of a red heart, emojis in pink, yellow, and green. There are all sorts of different types of stuff, like fruit. It's all up to you what you want to use. It even saves your frequently used ones.
If you want to talk about Twitter, you can use an emoji, too. It will look something like this:
Remember: To insert emojis, just hit CONTROL + COMMAND + SPACE on your keyboard.
Read it all: