How To Make A Degree Symbol On Google Sheets

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


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.

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.