In this Excel tutorial you will teach yourself how to insert degree symbol in your spreadsheet.
There are various ways to insert degree symbol.
Go to Ribbon to the Insert tab. Click Symbol button.
There are plenty of symbols. From Subset choose Superscripts and Subscripts. Degree symbol will be available in the middle of the screen.
Go to Ribbon to the Insert tab. Click Equation button. Expand the list of Symbols and choose Basic Math. Degree symbol will be available in the second line.
Insert character code
You can also insert degree symbol in Excel by using Character Map Windows application or character code. Just open Character Map, find degree symbol and copy it. Then you can paste it to your Excel spreadsheet.
Note: char keyboard shortcut for degree symbol is ALT + 0176 (using numeric keypad only).
Create a custom number format
The last way to insert degree symbol is to create custom number format. To do that just click CTRL + 1 keyboard shortcut. Next go to custom category and paste degree symbol from character map there.
I used more fancy format 0.0°F meaning it will fomat the content of cell with the numbers for fahrenheit temperature.
Use CHAR Excel function
It is enough to insert degree symbol by using CHAR function. The formula for degree symbol is =CHAR(176)
In this example the formula is =B2&CHAR(176)