Insert the Degree Symbol in Microsoft Excel

by Avantix Learning Team | Updated February 21, 2022

Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 and 365 (Windows)

You can insert or type the degree symbol in Excel using built-in commands, keyboard shortcuts or a custom number format. A custom number format can be applied to cells and would apply the degree symbol as a format rather than inserting it. The degree symbol can be entered in cells, equation blocks or text boxes. It is automatically entered in superscript. The term degree is used in several temperature scales including Celsius and Fahrenheit.

In this article, we'll review 5 ways to insert the degree symbol in Excel:

  1. Use the Insert Symbol command
  2. Press Alt and then enter a number sequence
  3. Use a built-in AutoCorrect shortcut
  4. Create and apply a custom number format
  5. Use the Equation tab in the Ribbon to insert the degree symbol in an equation block or placeholder

Recommended article: How to Insert Multiple Rows in Excel (4 Fast Ways with Shortcuts)

Do you want to learn more about Microsoft Excel? Check out our virtual classroom or in-person classroom Excel courses >

To insert an equation block in Excel:

  1. Click the Insert tab in the Ribbon.
  2. Click Symbols. A drop-down menu appears.
  3. Click Equation. An equation block is inserted on the worksheet.

1. Inserting the degree symbol using Insert Symbol

To insert the degree symbol using Insert Symbol in an Excel worksheet

  1. Click in the cell, text box or equation block where you want to insert the degree symbol. Double-click the cell if you want to edit a cell that has other content.
  2. Click the Insert tab in the Ribbon.
  3. In the Symbols group, click Symbol. A drop-down menu appears.
  4. Click More Symbols. A dialog box appears.
  5. If necessary, click the Symbols tab.
  6. Select (normal text) from the Font drop-down menu.
  7. Select Latin-1 Supplement from the Subset menu.
  8. Click the degree symbol.
  9. Click Insert.
  10. Click Close.

The Insert Symbol dialog box displays the degree symbol when you select normal text as the font and Latin-1 Supplement as the subset:

Insert symbol dialog box in Excel with degree symbol selected.

2. Using Alt keyboard shortcuts to insert the degree symbol

You can press the Alt key in combination with numbers on the numeric keypad to insert the degree symbol:

  1. Click in the cell, text box or equation block where you want to insert the degree symbol. Double-click the cell if you want to edit a cell that has other content.
  2. Press Alt + 0176 or Alt + 248 on the numeric keypad.

If these sequences don't work, press the NumLock key on the numeric keypad.

If you don't have a numeric keypad, you may be able to press the Fn key and access the numbers at the top of your keyboard.

3. Inserting the degree symbol using a built-in AutoCorrect shortcut

To use a built-in AutoCorrect shortcut in Excel to insert the degree symbol:

  1. Click in the cell, text box or equation block where you want to insert the Greek symbol.
  2. Type (d) and then press the Spacebar.

4. Creating a custom number format to insert the degree symbol in a format

The best way to insert the degree symbol to cells with numbers that you want to use in calculations is to create a custom number format. Once you create the format, you can apply it to cells containing numbers and you will still be able to perform calculations on the numbers (like calculate average temperature).

Custom number formats have up to 4 parts separated by semi-colons. The first part affects positive numbers, the second part affects negative numbers, the third part affects zero values and the fourth part affects text. Literal text needs to be enclosed in quotation marks ("") and zeros force digits to display.

To create a custom number format to apply the degree symbol as a format:

  1. Insert the degree symbol using Insert Symbol or one of the methods above.
  2. Double-click the cell and drag over the degree symbol.
  3. Press Ctrl + C to copy the symbol.
  4. Press Ctrl + 1 to display the Format Cells dialog box.
  5. Click the Number tab.
  6. In the categories on the left, click Custom.
  7. Delete the format that appears in the Type area.
  8. Enter a positive number format. For example, enter # and then type quotation marks or double quotes (") and press Ctrl + V to paste in the degree symbol. Type quotation marks after the degree symbol. You could add C or F in the quotation marks if you want to indicate Celsius or Fahrenheit.
  9. Type a semi-colon to create a negative format part and repeat the process with a minus sign at the beginning of the part.
  10. Type a semi-colon to enter a zero value part and enter the format such as 0"°C". At this point, if you are including a C for Celsius, the custom number format would be #"°C";-#"°C";0"°C". In this case, you would use Ctrl + V each time to insert the degree symbol.
  11. Click OK.

If you wanted to display two decimal places after the number, you could create one of the following formats:

#.00"°";-#.00"°";0.00"°"

#.00"°C";-#.00"°C";0.00"°C"

#.00"°F";-#.00"°F";0.00"°F"

In the following example, a custom number format for degrees has been entered in the Type area in the Format Cells dialog box:

Custom number format for degrees entered in the Format Cells dialog box in Excel.

Custom number formats can now be applied to selected cells. Note that custom number formats are only saved in the current workbook.

To apply a custom number format:

  1. Select the cells where you want to apply the format.
  2. Press Ctrl + 1.
  3. Click the Number tab.
  4. In the categories on the left, click Custom.
  5. Scroll through formats on the right.
  6. Click the custom number format (custom number formats appear at the bottom of the list).
  7. Click OK.

5. Inserting the degree symbol in an equation block using the Equation tab in the Ribbon

To insert the degree symbol in an equation block or placeholder using the Equation tab in the Ribbon:

  1. Select the Excel worksheet where you want to insert an equation.
  2. Click the Insert tab in the Ribbon.
  3. Click Symbol. A drop-down menu appears.
  4. Click Equation to insert a new equation block or placeholder. You can also use an existing equation block or placeholder.
  5. Ensure that you have clicked in the equation block and then click the Equation tab in the Ribbon.
  6. Click the More arrow on the bottom right of the Symbols gallery.
  7. At the top of the Symbols gallery, ensure Basic Math is selected from the drop-down menu.
  8. Click the degree symbol.

The Symbol gallery with Basic Math selected appears as follows with the degree symbol options for an equation:

Basic Math gallery in an Excel equation with degree symbol options.

You can also insert the degree symbol in an equation block using Alt codes or the Insert Symbol dialog box.

Subscribe to get more articles like this one

Did you find this article helpful? If you would like to receive new articles, join our email list.

More resources

How to Merge Cells in Excel (4 Ways with Shortcuts)

How to Combine Cells in Excel Using Concatenate (3 Ways)

How to Hide or Unhide Excel Worksheets (and Unhide All Sheets)

How to Delete Blank Rows in Excel (5 Fast Ways to Remove Empty Rows)

How to Highlight Errors, Blanks and Duplicates in Excel Worksheets (Using Formulas)

Related courses

Microsoft Excel: Intermediate / Advanced

Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools

Microsoft Excel: Introduction to Visual Basic for Applications (VBA)

VIEW MORE COURSES >

Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.

Copyright 2022 Avantix® Learning

You may also like

How to Password Protect Your Excel Worksheets and Workbooks

How to Password Protect Your Excel Worksheets and Workbooks

You can password protect worksheets and workbooks in Excel. If you want to prevent other users from opening or modifying an Excel workbook, you can encrypt the file with a password. You can also protect workbook structure where you can prevent users from deleting, renaming, moving or unhiding worksheets. Password protection can be added to your Excel file in several ways.

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning |18 King Street East, Suite 1400, Toronto, Ontario, Canada M5C 1C4 | Contact us at info@avantixlearning.ca

Summary
How to Insert or Type the Degree Symbol in Excel (5 Ways to Insert °)
Article Name
How to Insert or Type the Degree Symbol in Excel (5 Ways to Insert °)
Description
You can insert or type the degree symbol in Excel using built-in commands, keyboard shortcuts or a custom number format. A custom number format can be applied to cells and would apply the degree symbol as a format rather than inserting it so you would still be able to perform calculations on the cells. The degree symbol can be entered in cells, equation blocks or text boxes. It is automatically entered in superscript. The term degree is used in several temperature scales including Celsius and Fahrenheit.
Author
Publisher Name
Avantix Learning

Pin It on Pinterest

Share This