Google Docs is a free web-based office suite that allows you to create and share your work online. Besides, you can easily access your documents from any computers that are connected to the Internet. However, in the current version of Google Spreadsheet, you can’t insert special characters directly using the web application.
Therefore, the only way to insert special characters into the spreadsheet is to copy the characters from other sources and paste them into the file. In this tutorial, I will teach you how to use Character Map to copy the characters that you want. I’ve also provided a link with full list of special characters.
1. Go to your Google Drive account. Open your existing Google Spreadsheet file or create a new spreadsheet.
For Mac and Linux users, you can refer to the list of special characters online. Just copy the special characters that you want from the list and paste it into the spreadsheet.
2. If your are using Microsoft Windows, open Character Map. For Windows 7/8 user, simply type “charmap” in the start menu to open it. You can also go to Start -> All Programs -> Accessories -> System Tool -> Character Map.
3. Choose the correct font type for your special characters. Double click on the characters that you want to use. Then, press “Copy” to copy the characters to the clipboard.
4. Go back to your Google Spreadsheet and paste the characters (Ctrl + V or right click and paste) into the cell that you want. Done!
If you have discovered any better ways to insert special characters in gsheet file, feel free to share with me in the comment box below!
We Never Spam.