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!

**Table of Contents**hide

**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.