Internet Productivity

How to Insert Special Symbols and Characters in a Google Spreadsheet

Saikat Basu 05-04-2018

From copyright symbols to plain checkmarks, special characters are needed now and then. So, you may be surprised to know that Google Sheets has no way to insert a special character in its menu.


But there are two workarounds that will help you jump the hurdle and work better on Google Drive 10 Google Docs Tips That Take Seconds and Save You Time Learn some secrets that'll boost your Google Docs productivity with the help of these quick and simple tips. Read More .

Method 1: Use the Windows Character Map

How to Insert Special Symbols and Characters in a Google Spreadsheet Windows 10 Character Map

If you are on Windows 1o (or any other version), then you can use the native Character Map to copy and paste a special character into a Google Sheet.

  1. Launch Character Map.
  2. Pick the desired font for your special characters. Double click on the characters that you want to use. Press the Copy button to copy the characters to the clipboard.
  3. Open your Google Spreadsheet. Paste the characters (Ctrl + V or right click and paste) into the cell that you want.

Method 2: Use Google Docs + Google Sheets

Google Docs Character Map

Surprisingly, Google Docs has a native Character Map which is missing on Google Sheets. So, this can become the tool to “share” a special character within the same Google Drive.

  1. Open your spreadsheet and also open a Google Doc.
  2. Go to the Google Docs. Click on Insert > Special Characters.
  3. The special character is inserted into Google Docs first. Copy this special character in Google Docs and paste it into your spreadsheet.

Either of these methods should solve the problem of “missing” special characters in Google Sheets. For more, check out the best resources to identify any symbol online 6 Ways to Find Symbols and Look Up Symbol Meanings Need help identifying a symbol? Here's how to find any symbol by picture, how to search symbol libraries, and more. Read More .

Related topics: Google Drive, Google Sheets.

Affiliate Disclosure: By buying the products we recommend, you help keep the site alive. Read more.

Whatsapp Pinterest

Leave a Reply

Your email address will not be published. Required fields are marked *

  1. Karen
    July 16, 2019 at 1:23 pm

    That's what I needed to know. Thanks for the help. I was just trying to put a check mark in a matrix, but I didn't really want to use a check box.