Special characters are useful to spice up your Google Sheets. You can insert special characters without add-on in Google Sheets that including emojis.

I normally use special characters like pointing hand ☞, clockwise arrow ⃕, heart ❤ symbol, objects like telephone ☎ etc. in Google Sheets. All these you can insert into cells in Google Sheets and adjust the size and also change the color.

I have seen Google Sheets add-on that we can use to insert special characters and emojis in Google Sheets. As a blogger, not a Google Sheets user, I am not a big fan of add-ons.

The reason, I find myself many add-on publishers change their ‘color’ later. Just imagine that you had introduced a free add-on to your friend and later found that the add-on is now a paid one or discontinued their service. I have faced such a dilemma many times in the past with Chrome add-ons.

Back to the topic. To insert special characters in Google Sheets, the better option is to depend on Google Docs. At the time of writing this post, there is no option within Google Sheets to insert special characters and emojis.

How to Insert Special Characters Without Add-on in Sheets

Steps:

Go to Google Docs Word Processor, it’s free for personal use. Then create a new document.

Click the Insert menu drop-down and choose Special characters.

This will open the Special characters window. In that window, you can find the special character that you want in different ways.

You May Like: Create a Clickable Table of Contents in Google Docs.

I don’t know which is the easiest option for you. You can pick from categories like Symbol, Emoji, Punctuation, Number etc. Also, search the special character that you want.

Also, there is a unique way to find a special character. You can draw to search special characters in Google Docs.

Once found, click on the special character to insert it. Then select and copy the inserted special character and paste it in Google Sheets.

Follow this method to insert Special Characters Without Add-on in Google Sheets.

How to Change Special Character Color in Google Sheets

To change special character color treat it as normal fonts. That means you can change the color and size of special characters like normal fonts in Google Sheets.

Related Reading:

1. How to Highlight Cells Containing Special Characters in Google Sheets.
2. How to Restrict Entering Special Characters in Google Sheets Using Regex.