Skip to main content

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.

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

  1. Select a cell where you want to insert the degree symbol.
  2. Enter the following formula and press Enter.
    =CHAR(176)
    This formula returns a degree symbol as shown in the above screenshot.
Notes:
  • You can combine this formula with other text strings to create more comprehensive text entries that include the degree symbol. For example, to create a cell entry that reads 25° Celsius, you would enter the following formula:
    =25 & CHAR(176) & " Celsius"
  • In this example, if the number 25 is located in cell A10 and you want to reference it, apply the following formula:
    =A10 & CHAR(176) & " Celsius"

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.

  1. Select a cell or double click on a cell to place the cursor where you want to insert the degree symbol.
  2. Go to the Insert tab, click Symbol.
  3. In the Symbol dialog box and under the Symbols tab, you need to do as follows.
    1. Choose Times New Roman in the Font drop-down list.
    2. Find and select the degree symbol from the listed symbols.
    3. Click the Insert button.
      Then you can see the selected degree symbol is inserted into the cell.
  4. Close the Symbol dialog box when you have finished inserting.
Tip: When you open this Symbols dialog box next time, you can easily find the used degree symbol in the Recently Used Symbols section.

Using Autocorrect

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.

  1. Go to the File tab, click Options.
  2. In the Excel Options dialog box, select Proofing in the left pane, and then click the AutoCorrect Options button. See screenshot:
  3. In the AutoCorrect dialog box, you need to configure as follows.
    1. 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.
    2. Click on the With box, hold down the Alt key and press 0176. Then release the Alt key to show the degree symbol.
    3. Click the Add button.
    4. Click the OK button to save the settings.

Result

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.

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

  1. Select the degree symbol you want to save.
  2. Click the Add selected content to Resource Library button.
  3. Name the degree symbol in the Name box of the dialog box that opens.
  4. Choose a group or create a new group as you need to save this symbol.
  5. Click the Add button. See screenshot:

Result

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.

  1. Select the range of cells where you want to insert degree symbol, press the Ctrl + 1 keys to open the Format Cells dialog box.
  2. In the Format Cells dialog box, stay in the Number tab and configure the settings as follows.
    1. Select Custom in the Category list.
    2. 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.
    3. Click OK to save the settings.

Result

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.

  1. Select the range of cells where you want to add degree symbols.
  2. Press the Alt + F11 keys to open the VBA editor.
  3. 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
    Sub InsertDegreeSymbol()
    'Updated by Extendoffice 20240117
        Dim cell As Range
        For Each cell In Selection
            cell.Value = cell.Value & "°"
        Next cell
    End Sub
    
  4. Press F5 key to run this script to add the degree symbol to each cell in your selected range.
Notes:
  • 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.

Best Office Productivity Tools

Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

kte tab 201905


Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!