How To Insert Special Characters In Google Spreadsheet

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.

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.

Choose the right font type and copy the character 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!

Paste the special characters into Google Spreadsheet

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!

At least I'm not an annoying pop-up

If you like our posts, you should give our email list a try. We'll only send you 2-4 emails a month. We hate spam as much as you do!

Comments on this entry are closed.

Follow Us

Yeah, Another Sign Up Box

But seriously, if you like our posts, consider to give our email list a try. We'll only send you 2-4 emails a month, right when new articles come out.

We Never Spam.