Insert degree symbol in Excel to enhance the clarity and professionalism of your data, especially when dealing with temperature measurements, angles, or geographic coordinates. This small but significant addition can make a big difference in the readability and understanding of your data. Whether you’re a scientist recording experimental temperatures, a mathematician noting angles, or a geographer mapping out coordinates, this guide will provide you with straightforward steps to insert the degree symbol in Excel. By mastering this simple technique, you’ll ensure your data is accurately represented and easily interpretable, adding a polished touch to your spreadsheets.
There are some simple but very easy and effective ways of inserting a degree symbol in our worksheet if needed.
This Content Covers:
- Definition of Degree Symbol
- How to insert Degree symbol in Excel
- Using a Keyboard Shortcut
- Using Copy Paste method
- Using CHAR Function
- Using Symbol Dialogue Box
- Using Excel AUTO Correct
- Using Custom Number Format
- Using the Equation Tab
- Using VBA Code
1. Definition of Degree Symbol
When dealing with a certain type of data, we must utilize a special symbol called a degree symbol. A superscripted or suggested little circle serves as the Degree symbol in Microsoft Excel. Typically, it is used to indicate temperatures, angles, and geographic locations.
2. How to Insert Degree Symbol in Excel
In this tutorial today you will learn the ways by which you can insert a degree symbol in your worksheet while working with certain data.
2.1 Using a Keyboard Shortcut to insert degree symbol
To insert degree symbol using the keyboard shortcut, first select the cell and then press F2 key to enable edit mode. Then hold ALT key and press 0176. So, the keyboard shortcut is ALT(HOLD)+0176.
This keyboard shortcut works in 10 keys numeric keypad. You have to enable the number lock first to use this shortcut if you don’t have a numeric keyboard.
2.2 Using Copy Paste method
Step 1: After you have a degree symbol in your excel sheet using the method above, you can simply copy and paste it as many times as you want. Right click on the Degree symbol and select copy.
Step 2: Now right click on any cell you want to paste that symbol and select paste. Or you can use the shortcut CTRL+C to copy and CTRL+V to paste.
2.3 Using CHAR Function
Step 1: Select a cell you want to insert a degree symbol and type the formula given below.
=CHAR(176)
Step 2: Press ENTER and you will have a degree symbol inserted in that cell.
Step 3: You can combine this formula with number or digits or some other string, use the formula shown in the picture below.
Step 4: You can also combine it with a cells data or reference.
=Cell Location&CHAR(176)
2.4 Using Symbol Dialogue Box
Step 1: Select a cell the click Insert>>Symbol.
Step 2: Find the degree symbol inside the Symbol dialogue box by scrolling down and then click Insert.
2.5 Using Excel AUTO Correct
Step 1: Select File>>Options.
Step 2: Click Proofing>>AutoCorrect Options inside Excel options dialogue box.
Step 3: Type something you want as a replacement of degree symbol in the box labeled as Replace and put a degree symbol in the box labeled as With by copying the symbol from your worksheet. Click OK.
Step 4: Now whenever you type it in a cell and press ENTER it will replace the text with a degree symbol.
2.6 Using Custom Number Format
Step 1: Select the cells you want to insert degree symbol and click CTRL+1 command to activate the Format Cell dialogue box. Select Number>>Custom and inside the Type box type a digit or a number you want to use as custom number and paste a degree symbol with it as shown below.
Step 2: Now whenever you type a number in those cells, a degree symbol also will be inserted with it.
2.7 Using the Equation Tab
Step 1: Click on Equations under the Insert tab. A drop-down menu will appear, select any equation from there.
Step 2: Now select the degree symbol from Equation tab under Equation Tools. Copy the degree symbol from the formula and paste it in a cell then delete the formula.
2.8 Using VBA Code
Step 1: Select the cell you want to insert a degree symbol and right click on your current Sheet. Select View Code.
Step 2: Copy and Paste the formula given below inside the VBA dialogue box. Click on Run, cancel the dialogue box and return to your worksheet. A degree symbol has been inserter in that cell.
Sub AddDegreeSymbol()
Dim MyCell As Range
For Each MyCell In Selection
MyCell.Value = MyCell.Value & “°”
Next MyCell
End Sub
Application of ‘insert degree symbol’ in real world scenarios
- Weather Reporting: Meteorologists insert the degree symbol when reporting temperature data in weather forecasts to indicate Celsius or Fahrenheit.
- Academic Research: Researchers in fields like physics or chemistry use the degree symbol to denote temperature in scientific reports and papers.
- Geographical Mapping: Cartographers and geographers include the degree symbol in maps to accurately represent latitude and longitude coordinates.
- Engineering Plans: Engineers insert the degree symbol in technical drawings and plans to denote specific angles or orientations.
- Cooking and Baking Recipes: Recipe writers use the degree symbol to provide precise oven temperature settings, ensuring culinary accuracy.
- Educational Material: Educators use the degree symbol in teaching materials for subjects like mathematics, physics, or geography to denote angles, temperatures, or geographic coordinates.
You may be interested:
