In this article:

How to Add Emojis to Google Sheets (Easiest Way in 2024)

Google Sheets Emojis

Google Sheets does not have its own unique set of emojis. Instead, when you insert emojis into a Google Sheets document, it uses the standard emojis that are available through your operating system's emoji keyboard or through special commands like @emoji. These emojis are the same ones you would find on your smartphone, in email clients, or on social media platforms.

How to Add Emojis to Google Sheets 

Follow the steps below to easily add emojis to Google Sheets. 

1. Click on Cell Where Emoji Will Be Added

Select the cell where you want to place the emoji by clicking on it. 

google sheets emojis

2. Enter @emoji Command in the Selected Cell

In the active cell, type @emoji followed by a space. This special command signals Google Sheets to initiate the emoji search feature. 

emojis in google sheets

3. Type Emoji Name to Search and Select From List

After typing @emoji, you can select among the emojis available on the platform. You can also type the name of the emoji you're looking for, such as "heart" or "smile". Click on the emoji that best fits your needs. 

emojis google sheets

4. Confirm Emoji Selection to Insert in Cell

By clicking on an emoji from the dropdown list, it automatically gets inserted into your selected cell. The emoji will now be visible in the cell, and you can insert multiple emojis in the same cell by repeating the @emoji command followed by the emoji's name. 

how to add emojis to google sheets

5. Adjust Font Size to Change Emoji Size (Optional)

If the inserted emoji appears too small or too large for your liking, you can adjust its size by changing the font size of the cell it's in. Navigate to the menu bar, locate the font size dropdown menu, and select a different font size. 

We hope that you now have a better understanding of how to add emojis to Google Sheets. If you enjoyed this article, you might also like our article on how to rotate text on Google Sheets or our article on how to keep leading zeros in Google Sheets. 

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started