You need to learn how to insert and use a degree symbol in a cell. That’s right.
Let me tell you why I’m saying this. Yesterday I was working on some temperature data. For that, one of the important things was to use the degree symbol in data to show numbers in Celsius and Fahrenheit.
If you use a laptop like me, you’ll find that there is no key to type a degree symbol.
Important: While putting a degree symbol in a cell, you need to take care that, it always follows the number without any intervening space.
Top 5 Ways to Add a Degree Symbol in Excel Quickly
While working on that data I found that in Excel you can enter/type a degree symbol using five different ways. And one more good news is, that these methods are the same in Windows and MAC versions of Excel. So, let’s get started.
1. Add a Degree Symbol using a Keyboard Shortcut
A keyboard shortcut key is a quick and simple way to add this symbol to a cell. You can use Alt + 0 1 7 6 to insert it.
- First of all, select the cell where you need to enter it.
- Press F2 to edit the cell.
- And in the end, hold the ALT key and press 0 1 7 6 from the numeric keypad.
Once you enter it you can also copy and paste it into other cells instantly or you can press this shortcut key for every cell one by one.
2. Using CHAR Function to Add a Degree Symbol
If you are familiar with the CHAR function then I’m sure you know that you can insert some special characters with it.
By using this function, you can also add a degree symbol with a number to show it as Celsius or Fahrenheit.
All you have to do: Insert the CHAR function in a cell and specify 176 in the argument and press enter. Once you do that it will return a degree symbol.
And if you want to add it with a number you just need to insert a formula like the one we have below.
=29&CHAR(176)And press enter. The other way is to combine this formula with IF and ISNUMBER so that if there will be a number in the cell it will combine that number with a degree.
3. Insert Degree Symbol from Symbol Dialogue Box
If you want to add a degree symbol just one time then you can also insert it from the symbol dialog box. Follow these simple steps:
- Select the cell where you want to insert it and then go to Insert ➜ Symbols ➜ Symbol.
- In the dialogue box, select “Latin-1 Supplement” from Subset and select the degree symbol from all the symbols.
- In the end, click on Insert and then close.
You can also copy-paste into other cells or even you can insert a formula as well.
4. Using Excel AUTO Correct to Add a Degree Symbol in a Cell
In Excel, there is an option called auto correct which you can use to add a degree symbol in a cell by using an abbreviation. It works something like this.
You enter DYGR in a cell and Excel converts (autocorrect) it into a real degree symbol.
But first of all, you need to create this auto-correct, and here are the steps:
- Go to File ➜ Excel Options.
- In the Options dialogue box, select Proofing ➜ Autocorrect Options.
- In the Autocorrect dialogue box, enter DYGR in replace input box and a degree symbol (Use a shortcut key to insert it) in with the input bar.
- Click Add and then OK.
Now, if you type the text DYGR, it will automatically get converted into a degree symbol.
Important: This auto-correct is case sensitive and applied to all the Office application like Word, Powerpoint etc.
5. VBA Code to Quickly Insert a Delta Symbol in a Cell
VBA codes are time savers. I’m sure you know that. And, the code which I’m gonna share with you next is one of those codes.
Let’s say you have a list of numbers in a column and you want to add a degree symbol with all of them. Now, here the best way is to run this macro in a single go.
- First of all, add the below code in your VB editor.
- After that, select all the cells where you want to insert these symbols.
- And simply run this code from the developer tab.
Sub degreeSymbol()
Dim rng As Range
For Each rng In Selection
rng.Select
If ActiveCell <> "" Then
If IsNumeric(ActiveCell.Value) Then
ActiveCell.Value = ActiveCell.Value & "°"
End If
End If
Next
End SubThis code checks each and every cell of the range and inserts a degree symbol at the end in every cell.
Conclusion
A degree symbol is a specific symbol that we require to use with a specific kind of data (temperature). It’s better to have 5 different methods to insert it so that you can choose one of those according to your convenience.
I hope you found these methods useful and now tell me one thing.
Do you have any other method to insert this symbol?
Please share with me in the comment section, I’d love to hear from you. And don’t forget to share this tip with your friends.
Thanks for the helpful tips, this is great. I found you by searching on how to enter the degrees symbol in excel. I like the Options/proofing and replace dygr with the symbol and it works for me in a blank cell or if there’s a space between the temp number and the symbol, the spaces are undesirable. The problem i have is that you have to have a space between the temperature number and the dygr in order for it to work. Am i doing it wrong or am i missing something? Can it be done without a space?
The best way to add a degree sign to a number in a cell, is to apply a number format that includes the degree sign, such as 0°, and you might want to include C or F as applicable: 0°C. This maintains the numerical nature of the cell, so it can be used for calculations.
Thanks for all of these approaches. You can simply use shift + option 8 for the degree symbol, as well. However, is there a way to enter the degree symbol and not have it interfere when you want to get an average temp over a range of time? None of these approaches will permit that. Can it be auto formatted similar to the $ sign for currency?
Thank,
I used to note with no. 1 – “Alt+0 1 7 6”
no. 2 doesn’t show me correct(show other language)
My VBA code as follow:
Sub degreeSymbol()
Dim cell As Range
For Each cell In Selection.Cells
If cell.Value “” Then
cell.Value = cell.Value & ChrW(176)
End If
Next
End Sub
Sub degreeSymbol()
Dim cell As Range For Each cell In Selection.Cells
If cell.Value <> “” Then
cell.Value = cell.Value & ChrW(176) End If
Next
End Sub
this one of the best way to insert degree symbol Alt + 0 1 7 6
I am trying to add a degree symbol to a horizontal axis range of temps. It goes from 0 degrees to 80 degrees. Nothing I can do will change this, is there a solution?
Plz show the star Code
Hellо there! I couⅼd have sworn I’ve been to your blog befpre but after gokng thгough some of the articlеs I reakizeԀ it’s new to
me. Νonetheless, І’m definitеly dеlighted I found it aand I’ⅼl be bοok-marking it and checking back often!
Hi Puneet
Excellent and encouraging messages from you for an old person like me,
Can we make the same code as above with a small change as below?
Soni, Hyderabad
//////////////////
Dim rng As Range
For Each rng In Selection
rng.Select
If ActiveCell “” Then
If IsNumeric(ActiveCell.Value) Then
ActiveCell.Value = ActiveCell.Value & Chr(176)
End If
End If
Next
Thanks for sharing Rajendra. Just need a small tweak…
Sub AddDegree() '~~~~~~~~~~~~~~~~~~~~~~~~ 'powered by https://excelchamps.com/ '~~~~~~~~~~~~~~~~~~~~~~~~ Dim rng As Range For Each rng In Selection rng.Select If ActiveCell.Value <> "" Then If IsNumeric(ActiveCell.Value) Then ActiveCell.Value = ActiveCell.Value & Chr(176) End If End If Next End SubYes, you are right
I am not sure why I did not check
Thanks in any case,
🙂
How about Alt “248”?
Is there a way to place the degree symbol and keeping the arithmetic properties so you do not get the “#VALUE!” prompt when performing statistical analysis?
Use Custom Formatting. 🙂
Thanks for sharing your gift with us. You areally blessed
Nice to learn new tips and tricks every day
alt 0176
6th method……MS Ofc Excel 2010 no “Latin-1 Supplement” symbol choices for °°, so I insert 176 from ASCII(decimal)
I want to make file split with data.
Can i know how to make
Macros
you could also set up a custom format using ###℃. This way would be preferable if it is a frequent requirement, or if you wish to apply it to a whole column
That’s cool! thanks for sharing.
Thanks… nice trick
Probably the best 1… 🙂