How to Insert Special Symbols and Characters in a Google Spreadsheet
Pinterest Whatsapp
Advertisement

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 & Save You Time 10 Google Docs Tips that Take Seconds & Save You Time When you dive down into the depths of the Drive, the right feature can help you create professional looking documents. Our speed tips will help you do it that much faster. 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.

Enjoyed this article? Stay informed by joining our newsletter!

Enter your Email

Leave a Reply

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