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 SheetsNow 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: https://blog.bettersheets.co/how-do-i-insert-emojis-into-google-sheets/
Read Better Sheets in the app Listen to posts, join subscriber chats, and never miss an update from Alea.
|
Key phrases
Older messages
You're Using Google Sheets All Wrong
Friday, January 6, 2023
Common mistakes that people make when using Google Sheets. I offer suggestions on how to avoid or fix these mistakes. Some of the mistakes mentioned include using too many grid lines, not using enough
5 Simple Ways to Take Your Google Sheets to the Next Level, Right Now
Thursday, January 5, 2023
Admit it, your Google Sheets suck. Let's unsuck them, FAST! Today I'm going to share with you five simple ways to make your sheets better. Five things that you can fix right now to make them
Wednesday, January 4, 2023
The worst things you can do in Google Sheets! But you can change your habits.
The Google Sheet Add-on That Can Save You From Headaches
Tuesday, January 3, 2023
See Google Sheets in a whole new light! The most eye-strain reducing add-on for Google Sheets, ever. Improve your productivity and increase your happiness in Google Sheets.
Think Like a Programmer | Develop The Mindset of an Apps Script Coder
Monday, January 2, 2023
Think Like a Programmer, or Develop The Mindset of an Apps Script Coder. From an experience Apps Script programmer, here are some ways I think you can think like a Programmer.
Tuesday, February 7, 2023
In the summer going into my junior year, I wanted to jump higher.
⏰ Cashflow Call in Just 2 Hours (Today 3pm CST)
Tuesday, February 7, 2023
Hey team! It's that time again…Cashflow call Tuesday. I've seen in the some of our groups a few of you who either have a YouTube channel, or are asking how to start and utilize one. Thus,
Closes Tomorrow • Feb 2023 Reading Promo • Newsletter • FB Groups posts to 50,000 members
Tuesday, February 7, 2023
Our Feb 2023 Newsletter Promo Close 2/8/2023 Join ContentMo's FEBRUARY 2023 Reading Promotion
Now I Know: The Man Who Did Well By Himself
Tuesday, February 7, 2023
(The title is a pun.) View this email in your browser · Missed one? Visit the Archives If you're looking to help the victims of the Turkey/Syria earthquake, CNN's "Impact Your World"
Tuesday, February 7, 2023
Your weekly 5-minute read with timeless ideas on art and creativity intersecting with business and life͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Human systems and the stuff they make
Tuesday, February 7, 2023
Also a mechanical navigation computer for Soviet spaceflight
Tuesday, February 7, 2023
Creators usually wait too long to reap the benefits of working with a virtual assistant.
Redesigning This Copywriting Tool
Tuesday, February 7, 2023
Redesigning an infographic to become a spreadsheet. Get the sheet here: Better Than Happy by BetterSheets.co
Tuesday, February 7, 2023
I've got a must-read post for you today about AI content writing. Narcis Bejtic from Content Refined explains some of the best strategies for how to use AI for content creation WITHOUT
[You're invited] Learn how to successfully run a one-person L&D department
Tuesday, February 7, 2023
View in Browser | Forward to a Friend Register here How to Successfully Run a One-person L&D Department Hello, How can a one-person department provide learning solutions for hundreds—if not