How To Add Degree Symbol In Excel – 5 Easy Ways

How To Add Degree Symbol In Excel: Hi friends! If you’re here, it means you want to learn How To Add Developer Tab In Excel. This guide will show you a simple and easy ways to do it.

This guide will show you five ways to easily insert the degree symbol (°) in Excel. You can do this by using a keyboard shortcut, the Symbol menu, or a formula. It’s a quick and simple process!

So, Let’s start reading this article without wasting any time.

How To Add Degree Symbol In Excel

While working with data in Excel, I discovered five simple ways to type or insert a degree symbol. The best part? These methods work the same on both Windows and Mac versions of Excel. Let’s see!

1. Use a Keyboard Shortcut

The fastest way to add a degree symbol is by using a keyboard shortcut. Here’s how:

Step 1: Select the cell where you want the symbol.

Step 2: Press F2 to edit the cell.

Step 3: Hold the ALT key and type 0176 on the numeric keypad.

Step 4: Release the ALT key, and the degree symbol will appear.

You can copy and paste it into other cells or use the shortcut again for each cell.

2. Use the CHAR Function

If you know the CHAR function, you can use it to insert special characters, including the degree symbol.

Step 1: Type =CHAR(176) in a cell and press Enter. It will show the degree symbol.

Step 2: To add it with a number (like for temperature), use a formula like =30&CHAR(176). This will display 30°.

You can also combine this with IF and ISNUMBER to automatically add the symbol to numbers.

3. Insert from the Symbol Menu

If you only need the symbol once, you can use Excel’s Symbol menu:

Step 1: Go to Insert → Symbols → Symbol.

Step 2: In the dialog box, select Latin-1 Supplement from the Subset dropdown.

Step 3: Find and select the degree symbol, then click Insert and close the box.

You can copy and paste it or use it in formulas.

4. Use AutoCorrect

Excel’s AutoCorrect feature can automatically replace text with a degree symbol. Here’s how to set it up:

Step 1: Go to File → Options → Proofing → AutoCorrect Options.

Step 2: In the “Replace” box, type DYGR.

Step 3: In the “With” box, insert the degree symbol (use the shortcut ALT + 0176).

Step 4: Click Add and then OK.

Now, whenever you type DYGR, Excel will replace it with the degree symbol.

Note: This is case-sensitive and works in other Office apps like Word and PowerPoint.

Also Read: How To Add Developer Tab In Excel

5. Use VBA Code

If you have a list of numbers and want to add a degree symbol to all of them, VBA code can save time. Here’s how:

• Open the VBA editor and paste the code below.
• Select the cells where you want the symbol.
• Run the code from the 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 cell in your selection and adds a degree symbol to any number.

Also Read: How To Add Checkbox In Excel

Conclusion

In short, adding a degree symbol in Excel is easy and can be done in different ways. You can use the ALT+0176 shortcut, the CHAR(176) function, or find it in the Symbols menu.

In this article, we provided 5 easy methods to insert degree symbol. Each method works well, so pick the one you like best. Once you know these tricks, you can easily show temperatures, angles, or other measurements in Excel.

Thank you for reading this article till the end!