Due to the ease of use, the clean interface, and the variety of features that give users flexibility, Google Sheets is one of the most widely used spreadsheet apps.
The app is perfect for users who want to sort out data and collaborate with others on the same spreadsheet in a quick and easy manner.
However, despite the handy features, the app lacks a built-in option for adding special characters that many people need to sort their data in a more orderly fashion.
But the good news is that there is a workaround that can enable you to insert check marks or different symbols into your spreadsheet.
To learn how to add characters in Google Sheets, just keep on reading.
2. Here you will see a character map with many special character options. You can search symbols by using keywords or by choosing one from the drop-down menus.
Another way you can insert symbols in your Google Sheets document is by using the ALT+ [number] codes.
To do that, just press the alt key and press on a number. You will see a symbol coming up the cells.
Here is an example:
In order to insert a special character in Google Sheets with this method, you need to know the codes for all the special characters.
And, in case you were wondering about a code for a specific special character here is a list where you can find it.
The third method you can use for inserting special symbols with the help of the character map in Windows and Mac.
To access the character map from a Mac computer press ctrl>cmd>space.
Copy a symbol and paste it into the spreadsheet.
Bonus reading: How to Indent in Google Sheets
For Windows users, type “character” in the search field and select the Character Map. You’ll see a pop-up map showing special characters.