How to Insert Degree Symbol in Excel (6 Suitable Methods)

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.

Insert Degree Symbol Using Built-in Feature in Excel

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

Insert Degree Symbol Using Built-in Feature in Excel

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.

Keyboard Shortcut with Number Pad to insert degree

  • 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


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)

Excel CHAR Function to Insert Degree Symbol

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

Use Excel Autocorrect Options Tool inserts degree

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

Use Excel Autocorrect Options Tool inserts degree

  • Our input symbol is added to the list now. Finally, press OK.

  • Go to Cell B4.
  • Input a space and then write DEG_SYM.

Use Excel Autocorrect Options Tool inserts degree

  • Now, press the Enter button.

Use Excel Autocorrect Options Tool inserts degree

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


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.

Use Custom Format to insert Degree

  • The Format Cells window appears.
  • Go to the Custom option from the Number tab.
  • Put this format “###°” in the Type box.
  • Finally, press OK.

Use Custom Format to insert Degree

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

VBA Code to Add Degree Symbol

  • We enter the VBA window.
  • Choose the Module option from the Insert tab.

VBA Code to Add Degree Symbol

  • 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

VBA Code to Add Degree Symbol

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


Related Articles

Alok

Alok

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo