How to Insert/Type DEGREE Symbol in Excel

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 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 Degree Symbol in Excel Quickly

While working on that data I have found that in Excel you can enter/type a degree symbol using five different ways.

And one more good news is, these methods are same in Windows and MAC versions of Excel.

So today in this post, I’d like to share with you all these methods.

1. Add a Degree Symbol using a Keyboard Shortcut

A keyboard shortcut key is a quick and simple way to add this symbol in a cell.

You can use Alt + 0 1 7 6 to insert it.

shortcut key to insert a degree symbol in excel
  • 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 in 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 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 a Celsius or Fahrenheit.

All you have to do:

Insert CHAR function in a cell and specify 176 in the argument and press enter.

Once you do that it will return a degree symbol.

insert a degree symbol in excel using char function

And if you want to add it with a number you just need to insert a formula like below.

=29&CHAR(176)

And press enter.

The other way is to combine this formula with IF and ISNUMBER so that if there is 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 for just one time then you can also insert it from symbol dialog box.

Follow these simple steps:

  • Select the cell where you want to insert it and then go to Insert ➜ Symbols ➜ Symbol.
insert a degree symbol in excel using from symbol dialog box
  • In the dialogue box, select “Latin-1 Supplement” from Subset and select the degree symbol from all the symbols.
insert a degree symbol in excel using from symbol dialog box insert and close
  • In the end, click on Insert and then close.

You can also copy paste in it in other cell or even you can insert in 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.

insert a degree symbol in excel using auto correct option

You enter DYGR in a cell and Excel converts (auto correct) 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 input bar.
  • Click Add and then OK.
insert a degree symbol in excel using auto correct

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

  • First of all, add below code in your VB editor.
  • After that, select all the cell where you want to insert these symbols.
  • And simply run this code from 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 Sub

This 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 which we require to use with specific kind of data (temperature).

It’s better to have 5 different methods to insert it so that you can choose one 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.

You must Read these Next

  1. Add Serial Number Column in Excel: Experts know the importance of serial numbers. Serial numbers are like salt [...]
  2. Bullet Points in Excel: Have you ever notice that there is no option to insert bullet Points in Excel? I have 6 different ways [...]
  3. Insert Checkmark in Excel: And then I figured out that he had a list of customers and wanted to add a check mark for every [...] 
  4. Insert a Timestamp in Excel: In general, it contains the current date and time, and we use it to capture completing time [...]
  5. Apply Strikethrough in Excel: When it comes to Excel, we don’t have any direct option to apply strikethrough to a cell. No button or [...]
  6. Count Words in Excel: But, when it comes to Excel there is no such option to count words. You can count the number of cells but [...]
  7. Count Unique Values in Excel: For this, you need to use a method which will count a value only one time and ignore it’s all the [...]
  8. Hide Formula in Excel: Hiding a formula is a simple way to do this so that others can’t able to see which formula you have used [...]
  9. Wildcard Characters in Excel: These wildcard characters are all about searching/looking up for a text with a partial match [...]
  10. Checkbox in Excel: And a checkbox is a small but powerful tool that you can use to control a lot of things by unchecking/checking [...]

Content Protection by DMCA.com
2018-11-16T06:13:27+00:00

8 Comments

  1. Mohan Mahadevan 13 Dec, 18 at 9:40 am - Reply

    Nice to learn new tips and tricks every day

  2. guest 14 Sep, 18 at 2:16 am - Reply

    alt 0176

  3. StanLovesJesus 10 Jul, 18 at 3:22 pm - Reply

    6th method……MS Ofc Excel 2010 no “Latin-1 Supplement” symbol choices for °°, so I insert 176 from ASCII(decimal)

  4. Ishwar 2 Nov, 17 at 9:34 am - Reply

    I want to make file split with data.
    Can i know how to make

  5. Ishwar 2 Nov, 17 at 9:33 am - Reply

    Macros

  6. Eldruid 29 Aug, 17 at 11:23 am - Reply

    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

    • Puneet Gogia 29 Aug, 17 at 11:29 am - Reply

      That’s cool! thanks for sharing.

    • Krish 30 Aug, 17 at 2:45 pm - Reply

      Thanks… nice trick

Leave A Comment