The quickest way: Alt code on Windows, Option key on Mac

On Windows, hold Alt and type 0176 on the numeric keypad, then release Alt. The degree symbol (°) appears when ready. On Mac, hold Option and press Shift + 8. Both methods work in any Excel cell without changing your keyboard layout or installing anything.

The numeric keypad method only works on the right side of your keyboard — the number row above the letters will not work. If your laptop has no numeric keypad, you can enable Num Lock on an external keyboard, or use one of the other methods below.

Key Takeaways

  • Windows users can type Alt + 0176 (using the numeric keypad) to insert a degree symbol in any Excel cell.
  • Mac users hold Option + Shift + 8 to type the degree symbol without changing any settings.
  • The Insert Symbol dialog works on both Windows and Mac and does not require memorizing codes.
  • You can format a regular number as superscript and type the letter "o" to create a degree symbol that matches your font size.
  • Once you type a degree symbol once, you can copy it and paste it wherever you need it in your spreadsheet.

Using the Insert Symbol dialog on Windows and Mac

If you do not have a numeric keypad or prefer not to memorize codes, the Insert Symbol dialog is reliable on both systems. On Windows, click the Insert tab, then Symbol (on the far right), then More Symbols. On Mac, click Insert, then Special Characters.

In the dialog box, type "degree" in the search field. The degree symbol appears in the results. Click it once to select it, then click Insert (Windows) or Insert (Mac). The symbol lands in your cell at the cursor position. You can close the dialog and keep working.

This method is slower than the Alt code, but it works the same way every time and requires no memorization. Many people keep this dialog open in a second window while working, especially if they type degree symbols often.

Creating a degree symbol with superscript formatting

If you want the degree symbol to scale with your text size, you can create one using superscript. Type the number or text you want, then type the letter o right after it. Select only that letter o, then press Ctrl + Shift + P on Windows or Cmd + Shift + P on Mac to make it superscript.

The letter o shrinks and moves up, creating a symbol that looks like a degree mark. This method is useful when you are mixing degree symbols with different font sizes in the same spreadsheet, because the superscript o grows or shrinks with the text around it. The actual degree symbol (°) stays the same size no matter what.

Copying and pasting a degree symbol you have already typed

Once you have typed or inserted one degree symbol anywhere in your spreadsheet, you can reuse it. Click the cell containing the degree symbol, select just the symbol, and press Ctrl + C (Windows) or Cmd + C (Mac) to copy it. Then click any cell where you need it and press Ctrl + V or Cmd + V to paste.

This is the fastest method if you need to type the symbol many times in one session. You can keep the symbol copied to your clipboard for as long as you are working on that spreadsheet, and paste it as many times as you need without opening any dialogs or remembering codes.

Typing degree symbols in a formula or cell with text

The degree symbol works the same way whether you are typing it in an empty cell or in the middle of a formula or text string. If you are writing "Temperature: 72°F", you can type the text, then use Alt + 0176 (Windows) or Option + Shift + 8 (Mac) to insert the degree symbol between the number and the letter.

In a formula, the degree symbol is just a character like any other. If you are concatenating text with the ampersand (&), you can include the degree symbol in a quoted string: =A1&"°" will add a degree symbol after the value in cell A1. Copy a degree symbol once, paste it into your formula bar, and Excel will treat it as a regular character.

Why the Alt code does not work on some keyboards

The Alt + 0176 method fails on laptops without a numeric keypad, on external keyboards that do not have Num Lock, or on non-US keyboard layouts. If you press Alt and the number row and nothing happens, your keyboard does not have a numeric keypad active.

External numeric keypads (small separate devices) work with most laptops and are inexpensive if you type codes often. Otherwise, the Insert Symbol dialog or the Mac Option + Shift + 8 shortcut will work on any keyboard. Some gaming keyboards and programmable keyboards let you create custom shortcuts for symbols, but that requires setup in the keyboard's software.

Frequently Asked Questions

Can I save a degree symbol as a keyboard shortcut in Excel?

Excel does not have a built-in shortcut customization feature for single characters. However, if you use the degree symbol constantly, you can create a custom AutoCorrect entry: type the degree symbol in a cell, copy it, go to File > Options > Proofing > AutoCorrect Options, paste the symbol in the "Replace with" field, type a code like "degr" in the "Replace" field, and click Add. Then typing "degr" and pressing Space will auto-replace it with the degree symbol.

Does the degree symbol work in Excel formulas and charts?

Yes. The degree symbol is a regular character and works anywhere text appears in Excel — in cells, formulas, chart titles, axis labels, and comments. It does not affect calculations or formulas. If you are building a chart title that says "Temperature (°C)", you can type the degree symbol the same way you would in a cell.

Why does my degree symbol look different from someone else's?

The degree symbol's appearance depends on your font. Some fonts make it rounder, others more angular. If you need it to match a specific look, try changing the cell font. The actual character is the same; only the visual style changes. If you used the superscript o method instead of the true degree symbol, it will look noticeably different because it is a letter, not a symbol.

Can I type a degree symbol on a phone or tablet in Excel Online?

On most phones, open the keyboard and look for a numbers or symbols button (usually labeled "123" or "?!"). Swipe through the symbol pages until you find the degree symbol, or search for it if your keyboard has a search feature. On iPad, the process is similar — tap the number key, then look for the symbol. Excel Online accepts the symbol the same way as desktop Excel.