How To Insert Symbols In Google Sheets

Google Sheets, an integral part of the Google Drive suite, is a robust spreadsheet application. Its functionality extends beyond basic number crunching, allowing you to perform intricate tasks, including inserting symbols. This post will walk you through the steps required to accomplish this task.

Method 1: Using Insert Special Characters Feature

One of the most straightforward ways to insert symbols in Google Sheets is by using the ‘Insert special characters’ feature. Here’s how:

  1. Open your Google Sheets document.
  2. Click on the cell where you want to insert the symbol.
  3. Navigate to the menu bar and click on “Insert“.
  4. In the dropdown menu, select “Special characters“.
  5. A dialog box will appear. You can either search for a symbol by its name or draw it in the drawing pad provided. Once you find your desired symbol, click on it to insert it in the selected cell.

Method 2: Using Char Function

Another way to insert symbols in Google Sheets is by using the CHAR function. This method is particularly useful when you need to insert the same symbol multiple times.

Here’s the syntax for the CHAR function:


Replace ‘number’ with the ASCII value of the desired symbol.

For instance, if you want to insert the symbol for copyright ©, you would use the following function:


Once you’ve entered your function, press Enter and the desired symbol will appear in the selected cell.


Understanding how to insert symbols in Google Sheets can enhance your ability to effectively present data. Whether it’s adding currency symbols or including special symbols in your data, the aforementioned methods will make your task a breeze.