Easily insert the degree symbol in Excel: A complete guide
In Excel, inserting special characters like the degree symbol (°) is essential for accurately representing data, especially in fields like science and geography. Despite its frequent necessity, many users find themselves unsure about how to efficiently insert this symbol into their Excel worksheets. This comprehensive guide covers several ways to insert the degree symbol in Excel, from easy keyboard shortcuts to advanced VBA scripting, enabling you to add this symbol to your data smoothly, whether in single cells or across large datasets.
Insert Degree Symbol to Cells One by One
The methods provided in this section are common methods used by Excel users to insert degree symbols. These methods are especially useful when you need to add degree symbols to a limited number of cells. We will demonstrate each of these methods below.
Using the Keyboard Shortcut
The easiest way to insert degree symbols in Excel is to use keyboard shortcuts.
For Windows users, you need to select a cell where you want to insert the degree symbol, type in the text as necessary, and then press Alt + 0176.
When you release the Alt key, the degree symbol will be displayed.
- The keyboard shortcut for inserting the degree symbol requires a numeric keypad. If your keyboard lacks a numeric keypad, you'll need to activate the Num Lock feature before using this shortcut.
- For Mac users, use this shortcut: Option + Shift + 8.
Copying and Pasting the Degree Symbol
If you don't remember the keyboard shortcuts above, but know exactly where to find the degree symbols, then copy and paste is also a good option.
A degree symbol is listed below, simply click the Copy button (or press Ctrl + C) to copy it and then paste (Ctrl + V) into Excel.
Using the CHAR Formula
You can also use the CHAR formula to insert a degree symbol in Excel. Please do as follows.
- Select a cell where you want to insert the degree symbol.
- Enter the following formula and press Enter.
This formula returns a degree symbol as shown in the above screenshot.
Using the Symbol Option
The Symbol Option in Excel allows you to insert different symbols as you need, including the degree symbol. Let’s see how to use the option to insert a degree symbol.
- Select a cell or double click on a cell to place the cursor where you want to insert the degree symbol.
- Go to the Insert tab, click Symbol.
- In the Symbol dialog box and under the Symbols tab, you need to do as follows.
- Choose Times New Roman in the Font drop-down list.
- Find and select the degree symbol from the listed symbols.
- Click the Insert button.
Then you can see the selected degree symbol is inserted into the cell.
- Close the Symbol dialog box when you have finished inserting.
: When you open this Symbols
dialog box next time, you can easily find the used degree symbol in the Recently Used Symbols
Using Excel's Autocorrect feature to insert the degree symbol streamlines data entry by automatically converting a predefined text string, like "deg" into the degree symbol, eliminating the need to remember formulas or keyboard shortcuts.
- Go to the File tab, click Options.
- In the Excel Options dialog box, select Proofing in the left pane, and then click the AutoCorrect Options button. See screenshot:
- In the AutoCorrect dialog box, you need to configure as follows.
- In the Replace box, enter a predefined text string that you want Excel to automatically convert to a degree symbol. In this case, the text I entered is deg.
- Click on the With box, hold down the Alt key and press 0176. Then release the Alt key to show the degree symbol.
- Click the Add button.
- Click the OK button to save the settings.
From now on, when you enter the predefined text deg in a cell and press the Enter or Space key, it will be converted to a degree symbol automatically.
- If the selected cell already contains text, ensure to separate the predefined Autocorrect text with a space from the original text. Without this separation, the text may not be correctly converted to the degree symbol.
- Autocorrect typically isn't case-sensitive, so the predefined text will be converted to degree symbol regardless of how you type its case in the cell.
Easily Save Degree Symbol in Excel for Future Use
If you frequently need to use a degree symbol, saving it in Excel for future use will save you a lot of time. Kutools for Excel's Resource Library pane makes it easy to save a degree symbol and make it available with a single click in the future, ensuring consistency in using the degree symbol across your worksheets, enhancing the accuracy and professionalism of your data presentation.
After installing Kutools for Excel, go to the Kutools tab, click Insert > Resource Library to open the pane.
- Select the degree symbol you want to save.
- Click the Add selected content to Resource Library button.
- Name the degree symbol in the Name box of the dialog box that opens.
- Choose a group or create a new group as you need to save this symbol.
- Click the Add button. See screenshot:
The degree symbol is now saved in a specified group in the Resource Library pane. When you need to use it, simply click on the symbol to insert it into the selected cell or cursor location.
Want to access this feature? Download Kutools for Excel now! Or you can click to know more about this feature.
Insert Degree Symbol to Cells in Bulk
To insert the degree symbol in multiple cells at once, this section provides two methods to help you accomplish this task.
Customizing Cell Formatting:
You can customize the cells formatting to add degree symbol to multiple cells at once.
Suppose we have a column of numeric cells as shown in the following screenshot, and we want to add the degree symbol after each number. Here’s how we can do to accomplish this task.
- Select the range of cells where you want to insert degree symbol, press the Ctrl + 1 keys to open the Format Cells dialog box.
- In the Format Cells dialog box, stay in the Number tab and configure the settings as follows.
- Select Custom in the Category list.
- In the Type textbox, place the cursor after the text “General”, hold down the Alt key and press 0176. Then release the Alt key to display the degree symbol.
- Click OK to save the settings.
Degree symbols are added to the selected cells at once as shown in the screenshot below. If you clear the range and add new numbers, the degree symbol will be automatically added after the new number.
Using VBA Code
For a more advanced approach, you can use Visual Basic for Applications (VBA) to insert the degree symbol to multiple cells in bulk. Please do as follows.
- Select the range of cells where you want to add degree symbols.
- Press the Alt + F11 keys to open the VBA editor.
- In the Microsoft Visual Basic for Applications window, click Insert > Module to insert a new module. And then copy the following VBA code to this new module.
VBA code: Insert degree symbol to a range of cells
'Updated by Extendoffice 20240117
Dim cell As Range
For Each cell In Selection
cell.Value = cell.Value & "°"
- Press F5 key to run this script to add the degree symbol to each cell in your selected range.
- If there is text content in each cell of the selected range, the degree symbol will be added to the end of the content as well.
- If the selected range is empty, the degree symbol will be added directly to the cell.
Whether you need to add the degree symbol to just a few cells or to a large dataset, this tutorial offers multiple ways to do it efficiently. From simple keyboard shortcuts to more complex methods, you now have a variety of options at your disposal. Remember, the choice of method can depend on the specific requirements of your task and your comfort level with Excel’s features. With this guide, inserting the degree symbol in your Excel worksheets should now be a breeze. For those eager to delve deeper into Excel's capabilities, our website boasts a wealth of tutorials. Discover more Excel tips and tricks here.