In this tutorial, you will learn how to make a degree symbol on Google Sheets.
The degree symbol is a small, superscript circle usually following a number that is used to denote temperature or angle measurement in degrees. For example: a temperature of 65°F or a 45° angle.
If you need to insert a degree symbol into your spreadsheet, read on to learn how
Copy and Paste Method
The simplest method to insert a degree symbol is to copy and paste it into you spreadsheet following these steps:
Step 1
Copy a degree symbol. You can either search for it on the internet or copy it from here: °. Select the degree symbol and use your computer’s copy keyboard shortcut to copy it. This will be CTRL + C on Windows or CMD + C on Mac
Step 2
Double click on the cell you want to add the symbol to to enter edit mode, then click where you want to insert the symbol to move the cursor there
Step 3
Hit CTRL + V on Windows or CMD + V on Mac to paste the copied degree symbol at the cursor location
CHAR() Function Method
Another method for adding the degree symbol is to use the CHAR() function. The CHAR() function allows you to insert characters by using their unicode number, in this case the number 176.
Here’s how:
Step 1
To use the CHAR function you’ll need to convert the text surrounding the symbol into a string formula. Do this by double clicking on the cell to edit it, then adding an equals sign at the start of the text to denote the start of a formula and wrapping the text in quotation marks, as in the image below
Step 2
Next, click on the location you want to insert the degree symbol and type the following, including the quotation marks at the beginning and end: “& CHAR(176) &” . This splits the string in half and uses the ampersand character to add in the CHAR() function that generates the degree symbol
Summary
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to make a degree symbol on Google Sheets. Want more? Check out all the Google Sheets Tutorials.