Follow the steps below to add special characters in Google Sheets.
Click on the specific cell in Google Sheets where you intend to insert an emoji.
Type the '@emoji' on your chosen cell in Google Sheets and select 'emoji' in the dropdown menu.
Select the emoji you wish to insert from the emoji keyboard and click on it to insert it into the selected cell.
For more diverse special characters (like mathematical symbols, arrows, and other pictographs) that are not available through the emoji keyboard, you can follow the steps below to insert special characters in Google Sheets using Google Docs.
In Google Docs, find the "Insert" option in the top menu, then choose "Special characters."
Use the search box or browse through categories in the "Special characters" dialog to find and select your desired character.
Select the special character that you have chose.
Copy the chosen special character to your clipboard with Ctrl+C or by using the right-click context menu.
In Google Sheets, select the cell where you want the character and paste it using Ctrl+V or the right-click context menu.
We hope that you now have a better understanding of how to insert special characters in Google Sheets. If you enjoyed this article, you might also like our article on the loan payment formula in Google Sheets or our article on fixing Google Sheets printing too small.
