Top 5 ways to insert Degree symbol in Excel | Complete guide with shortcuts
In this article, we’ll cover 5 ways to insert degree symbol in excel from copy pasting degree character (°) to using autocorrect to make degree sign.
In excel you have a wide variety of symbols to choose from such as delta symbol, cent symbol and even tick marks like checkbox and checkmark.
There is no degree symbol on keyboard which you can press that will insert the degree symbol. No need to worry we have a wide variety methods to do the same. Let’s see how to type degree symbol in excel.
What is degree symbol?
Degree symbol represents degrees of arc, hours in medical field, temperature and much more. You can read more about Degree Sign (°) here.
Now let’s go back to excel and look at how to type degree symbol.
Copy & Paste to type Degree Symbol in excel
This is the easiest method. Just copy the below degree sign and paste it in Excel.
Copy the degree sign, go to an excel cell. Double click the cell or press F2 and paste the degree sign symbol (CTRL + V)
Now you can copy and paste it as many times you want. This works best when there are only a few cells where you have to insert the degree symbol in excel but it’s better to use a formula when inserting it in 10s or 100s of cells.
Degree Symbol Shortcut (Workaround)
Below are the steps to use shortcut for degree symbol in excel.
- Select the cell where you want to insert the degree symbol.
- Double click or press F2 to go into edit mode.
- Press ATL + 0176 (Hold ALT key and then press 0176 from numeric keypad of your keyboard)
Note: This is going to work if you have a 10 key numeric keyboard. If you don’t first enable Num lock then use this degree symbol keyboard shortcut.
For Mac users, the shortcut for degree symbol is OPTION + SHIFT + 8
Also do remember that in excel there is no specific degree alt code or any specific degree symbol in ascii which you can use to as degree symbol shortcut in excel.
How to make Degree Symbol using Symbol Feature
This is also a very common way to put a degree symbol in excel.
- Select the cell where you want to insert degree symbol.
- Go to Insert tab, under symbols group select Symbol.
- In Symbols dialog box, open drop down menu of Font Select “Verdana”. You can now see various symbols, select the excel degree symbol and hit Insert.
- Now the degree sign has been inserted in the excel cell.
To insert more degree symbol in excel just copy the inserted one and paste it in other cells or just drag to other cells to copy.
How to type degree symbol using CHAR Formula
If you like working with formulas then just type =CHAR(176) to add degree symbol excel.
This formula can also be used with other text values or formulas. Let’s say you want to type 72° in a cell then just type =72&CHAR(176) or =A2&CHAR(176)
How to type degree symbol in Excel using AutoCorrect
If you use degree symbol everyday then this method is best for you. Excel AutoCorrects misspelled words automatically. But don’t worry it’s not as terrible as AutoCorrect on iPhone.
- Go to File tab and select Options.
- In Options dialog box, select Proofing. Now select ‘AutoCorrect Options’ button.
- In the opened dialog box, do the following:
- Write DGRSYM in Replace
- Copy & paste ° (This symbol) in With
- Click Add then OK.
Now go to any cell and type DGRSYM. Excel will automatically change it to excel degree symbol. You can type any text to auto correct it to ° symbol, I have used DGRSYM just for my reference.
Do keep in mind the following things to use this effectively:
- The value in Write field is case sensitive, so if you type dlgrsym it’ll not change to degree symbol.
- The changes might all get applied to other Microsoft Office applications like Word, Powerpoint etc.
- Also while typing if you insert any other text/number before or after DGRSYM it’ll get not get converted to degree symbol if there is no space. Example: ‘45DGRSYM’ will not get converted while ‘45 DGRSYM will get converted to ‘45 ° ’
Do learn about Excel AutoCorrect to understand the functionality and its working better.
Using VBA to add Degree Symbol to Numbers
We can create a VBA code and link it with a button to add degree symbol quickly or just run it manually.
This is the code that we need to use:
Dim SelectedCells As Range
For Each SelectedCells In Selection
SelectedCells.Value = SelectedCells.Value & “°”
- Now select the range of cells, go to Developer tab and click View Code.
- Visual basic window will open. Paste the code in the blank white space and click Run.
- Now go back to the sheet and see. All the numbers have a degree symbol now.
If you know how to work with VBA you can easily create a button which will run the code for you. You can learn about creating a button and using VBA code in excel.
That was all about how to make degree symbol in excel.
I hope this article was helpful to you and explained you all about degree symbol in excel, shortcut degree symbol and much more.
If you have any questions or tips, I’d love to hear them in the comment section below.
Advanced Excel Course
Learn Vlookup, Pivot tables, What IF, Macro Automation, Power Query and much more.
- 10+Hrs of Learning Content
- 50+ Practical Exercises
- Doubt Resolution