Adding degree symbols to Excel is essential for any data analyst who wants to present data in a more readable format. In this tutorial, we’ll go over several ways to add degree symbols quickly and easily to your Excel spreadsheets.
Method 1: Typing Degree Symbol Manually
If you want to add a degree symbol to a cell in Excel, you can type it manually. This method is straightforward and can be done quickly. Follow the steps below to learn how to add degree symbols.
- Select the cell where you want to add the degree symbol.
- Click this symbol: “^” followed immediately by the number 0. This will generate the degree symbol “°.”
Method 2: Using the CHAR Function
Another method for adding a degree symbol is by using the CHAR function. The CHAR function returns the character that matches the character code number. Its syntax is CHAR(number). The number used specifies which character to return. In this case, the code for the degree symbol is 176.
- Select the cell where you want to add the degree symbol.
- Type the following formula in the formula bar:
=CHAR(176) - Press enter.
Method 3: Using the Symbol Menu
Excel has a built-in symbol menu that allows you to add different symbols, including the degree symbol. This method is particularly useful when you need to add symbols to several cells at once. Follow these steps to use the symbol menu:
- Select the cell where you want to add the degree symbol.
- Go to the Insert tab and click on the Symbol icon found in the Symbols group.
- Select the degree symbol in the list of symbols and click on Insert.
Method 4: Using the AutoCorrect Feature
The AutoCorrect feature in Excel is a useful feature that can save you a lot of time when typing. It automatically corrects common typos and can also be customized to add symbols like the degree symbol. Follow the steps below to use this feature:
- Select the cell where you want to add the degree symbol.
- Type the letters “deg” followed by a space.
- The AutoCorrect feature will immediately replace “deg” with the degree symbol “°”.
FAQ
Q. How do I add degree symbols to multiple cells in Excel?
A. Method 3 is the best way to add degree symbols to multiple cells in Excel. You can use the Symbol menu to insert degree symbols into multiple cells at once. Here’s how to do it:
- Select the range of cells where you want to insert the degree symbol.
- Go to the Insert tab and click on the Symbol icon found in the Symbols group.
- Select the degree symbol in the list of symbols and click on Insert.
Q. How do I change the format of cells to display degree symbols?
A. If you’ve already added degree symbols to your cells but they’re not displaying, you might need to change the format of the cell. Here’s how to do it:
- Select the range of cells you want to format.
- Right-click and choose Format Cells from the context menu.
- In the Format Cells dialog box, select Number in the Category list.
- Select Custom in the Type list.
- Type 0″°” in the Type box. (The quotation marks are part of the format code, and the “°” is the degree symbol.)
- Click OK to close the dialog box.
How to Add Degree Symbols to Excel using a Keyboard shortcut
You can also use Keyboard shortcut to add degree Symbol to a cell in Excel by following some quick simple steps:
- Select the cell where you want to add the degree symbol.
- While holding down the Alt key from keyboard, press the right number pad key “0176”
- The degree symbol will appear in the cell.
Adding Degree Symbol to Microsoft Word using Insert Symbol
If you want to add a degree symbol in Microsoft Word follow the steps below:
- Click the “Insert” tab on the ribbon.
- Click the “Symbol” button in the “Symbols” section of the ribbon. The Symbol dialog box appears.
- Click the “Special Characters” tab.
- Select “Symbols” from the list on the left side of the dialog box.
- Find the degree symbol then double click on it or click”Insert” button then “Close”.
FAQ
Q. What is the shortcut key for the degree symbol in Microsoft Word?
A. There’s no definite shortcut key for the degree symbol in Microsoft Word. But, you can use the keyboard shortcut “Ctrl + @, spacebar” (the “@” symbol is the same as the degree symbol).
Q. How do I insert a degree symbol in a Word document by using a keyboard shortcut?
A. Here is how you can use the keyboard shortcut to make the degree symbol in Word document:
- Place the cursor where you want to insert the degree symbol.
- Hold down the “Alt” key from the keyboard then type the letters “0176” using the numeric keypad.
- The degree symbol will appear at the cursor’s position.
Video Tutorial
If you prefer video tutorials, here’s a great one that explains how to add degree symbols in Excel:
Adding a degree symbol to Excel is essential to present data more accurately and professionally. Whether you prefer to use a keyboard shortcut, the symbol menu, formulas, or the AutoCorrect feature, you can add a degree symbol with ease. Use these methods to make your Excel spreadsheets easier to read and more professional-looking.
