Alok Paul
The Degree (°) symbol is used in Trigonometry. It denotes the angle. But there is no single dedicated button on the keyboard so that we can directly input a Degree (°) symbol. However, we can use several orthodox and unorthodox techniques to insert a degree symbol in Excel.
In this article, we will discuss that with clear guidance. Stay tuned with us!
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
6 Methods to Insert Degree Symbol in Excel
We will discuss 6 different methods to insert the Degree(°) symbol in Excel. Our dataset has of some angles without the Degree(°) symbol. We will insert the Degree(°) symbol with the angles.
1. Insert Degree Symbol Using Built-in Feature in Excel
In this very first method, we will insert the degree symbol from the dialog box of the Insert tab.
📌 Steps:
- First, select and double-click Cell B4. Place the cursor where you want to insert the symbol.
- Now, click the Insert tab.
- Select the Symbol option from the Symbols group.
- A dialog box named Symbol will appear.
- Choose Arial as the Font.
- After that, select Latin-1 Supplement as the Subset.
- Now, select the Degree (°) symbol from a given symbol list.
- Finally, press the Insert button.
- Then, close the dialog box.
The Unicode name section indicates the name of the corresponding symbol.
- We can see the Degree (°) symbol is added with data of Cell B4.
- Follow this process for the rest of the cells. Or just copy the symbol you have already added.
After adding the Degree (°) symbol, the data are not more numeric. They behave like text data. As a result data on the left aligned.
Read More: How to Insert Symbol in Excel (6 Simple Techniques)
2. Use a Keyboard Shortcut with Number Pad
In this method, we will use the Keyboard shortcut. This is the easiest way to insert a Degree(°) symbol.
📌 Steps:
- Go to the desired cell where you need to insert the Degree(°) symbol. We went to Cell B4. Now, double-click on it.
- Now, Cell B4 is in editable mode. Press Alt + 0176 or 248.
- Look at Cell B4 now.
A degree symbol has already been added in Cell B4.
- Now, copy the Degree(°) symbol and paste it onto the rest of the cells.
Finally, Degree(°) is added to our data.
Note:
You must have the numeric pad on the keyboard to apply this method.
Read More: Excel Formula Symbols Cheat Sheet (13 Cool Tips)
Similar Readings
- How to Type Minus Sign in Excel Without Formula (6 Simple Methods)
- Put 0 in Excel in Front of Numbers (5 Handy Methods)
- How to Insert Dollar Sign in Excel Formula (3 Handy Methods)
- Add Currency Symbol in Excel (6 Ways)
- How to Insert Sign in Excel Formula (Arithmetic, Logical and Misc.)
3. Use Excel CHAR Function to Insert Degree Symbol
In this method, we will use the CHAR function to insert the degree symbol.
The CHAR function returns the character specified by the code number from the character set for your computer.
📌 Steps:
- We add a column named Number with Degree Symbol.
- Go to Cell C4.
- Put the following formula based on the CHAR function.
=B4&CHAR(176)
- Press Enter and drag the Fill Handle icon.
The Degree symbol is inserted with all cells of the 2nd column.
Or, you can produce the degree symbol using=CHAR(176)formula (then copy the value only) and use the symbol wherever you want.
4. Use Excel Autocorrect Options Tool
Excel AutoCorrect tool is commonly used to correct typos, capitalization mistakes, and misspelled words. We can use it to insert symbols in other words. AutoCorrect inherits a list of some common spelling mistakes and symbols. But we can modify this list according to our needs. In this section, we will add the Degree (°) symbol to the list of the AutoCorrect tool.
📌 Steps:
- Go to File >> Options from the worksheet.
- Now, the Excel Options window appears.
- Choose the Proofing option on the left side.
- After that, click on the AutoCorrect Options button.
- The AutoCorrect window appears.
- Write DEG_SYM in the Replace box and put the Degree (°) symbol on the With box.
- Then, click on the Add button.
- Our input symbol is added to the list now. Finally, press OK.
- Go to Cell B4.
- Input a space and then write DEG_SYM.
- Now, press the Enter button.
We can see the Degree (°) symbol is added. Also, unnecessary spaces are showing.
- Select the space and remove them by pressing the Delete button.
- Look at the dataset.
No spaces exist here.
- Similarly, add the Degree (°) symbol to the rest of the cells.
Note:
You can also use the TRIM function to remove unnecessary spaces.
Similar Readings
- How to Insert Rupee Symbol in Excel (7 Quick Methods)
- Insert Tick Mark in Excel (7 Useful Ways)
- How to Type Delta Symbol in Excel (8 Effective Ways)
- Type Diameter Symbol in Excel (4 Quick Methods)
- How to Insert Less Than or Equal to Symbol in Excel (5 Quick Methods)
5. Apply Custom Format to Copy Degree Symbol to All Cells
We will customize the Format Cells tool to insert a degree symbol in this method.
📌 Steps:
- Select all the cells first.
- Press the right button of the mouse.
- Choose the Format Cells option from the Context menu.
- The Format Cells window appears.
- Go to the Custom option from the Number tab.
- Put this format “###°” in the Type box.
- Finally, press OK.
- Look at the dataset now.
Here, on a single time applying the method we added degree to the dataset.
Note:
We inserted the degree symbol in the Type box by pressing Ctrl + 0176.
6. Use a VBA Code to Add Degree Symbol
We will use a VBA code that will insert the degree symbol just in one click.
📌 Steps:
- Go to the Sheet Name section at the bottom of any sheet.
- Press the right button of the mouse.
- Choose View Code from the Context Menu.
- We enter the VBA window.
- Choose the Module option from the Insert tab.
- VBA module opens. We will write VBA code here.
- Now, select all the cells of the Number column.
- Copy and paste the VBA code below on the module.
Sub insert_degree()
Dim range_1 As Range
For Each range_1 In Selection
range_1.Select
If ActiveCell <> "" Then
If IsNumeric(ActiveCell.Value) Then
ActiveCell.Value = ActiveCell.Value & "°"
End If
End If
Next
End Sub
- Now, press F5 to run the code.
- Have a look at the dataset now.
Here, the degree symbol is added just by running the VBA code.
Conclusion
In this article, we showed how to insert the degree symbol in Excel. We showed 6 different types of methods for this purpose. I hope this will satisfy your needs. Please have a look at our website Exceldemy.com and give your suggestions in the comment box.
