The fastest way depends on your keyboard and what you're typing
The degree symbol (°) appears in Excel the same way it does in any other program on your computer — but the method you use depends on whether you're on Windows or Mac, and whether you want to type it once or many times in the same spreadsheet.
On Windows, hold Alt and type 0176 on the numeric keypad, then release Alt. On Mac, hold Shift and Option together and press 8. Both methods work in any Excel cell. If your keyboard doesn't have a numeric keypad, or if you're typing the symbol repeatedly, copying and pasting or using Find & Replace is often faster than memorizing a key combination.
Key Takeaways
- Windows users can type the degree symbol by holding Alt and pressing 0176 on the numeric keypad, then releasing Alt.
- Mac users hold Shift and Option together and press 8 to produce the degree symbol.
- If you don't have a numeric keypad or need the symbol many times, copy a single degree symbol and paste it repeatedly, or use Find & Replace to add it to existing numbers.
- The Insert Symbol dialog (Windows: Insert menu > Symbol; Mac: Insert menu > Special Characters) works on any keyboard but takes longer for frequent use.
Windows: Using the Alt code method
The numeric keypad Alt code is the quickest method on Windows if your keyboard has a numeric keypad. Click the cell where you want the symbol, then hold down Alt, type 0176 on the numeric keypad (not the number row at the top of your keyboard), and release Alt. The degree symbol appears when ready.
This works because Excel recognizes the Alt code 0176 as the Unicode character for the degree symbol. The leading zero matters — typing Alt 176 without the zero will not work. If your keyboard is a laptop without a dedicated numeric keypad, you may have a Num Lock key that activates a hidden numeric keypad, usually on the right side of the letter keys. Check your keyboard manual or look for small numbers printed on the letter keys.
Mac: Using the Shift-Option combination
On Mac, hold Shift and Option at the same time, then press 8. Release all three keys. The degree symbol appears in the cell. This combination is consistent across all Mac applications, so once you learn it, you can use it in Word, Google Sheets, email, or any other program.
If the symbol does not appear, check that you are using the number 8 on the main keyboard, not on a numeric keypad (which Mac laptops do not have). The Shift-Option combination is faster than the Windows Alt code because it requires fewer keystrokes and works on any Mac keyboard without special configuration.
Using the Insert Symbol dialog on any keyboard
If you don't have a numeric keypad or can't remember the key combination, the Insert Symbol dialog works on any keyboard. On Windows, click the Insert menu, then select Symbol. On Mac, click Insert, then select Special Characters. A dialog box opens showing available characters.
In the Windows Symbol dialog, you can search for "degree" or scroll through the list until you find the degree symbol (°). Click it, then click Insert. In the Mac Special Characters dialog, type "degree" in the search box at the top. Click the degree symbol in the results, then click the Insert button at the bottom right. This method is reliable but slower than a keyboard shortcut, so use it when you need the symbol only once or twice.
Copying and pasting for repeated use
If you need the degree symbol many times in the same spreadsheet, type or insert it once using any method above, then copy it. Select the cell containing the symbol, press Ctrl+C (Windows) or Command+C (Mac), then click each cell where you need it and press Ctrl+V (Windows) or Command+V (Mac). This avoids repeating the key combination or dialog steps.
You can also keep the degree symbol in a text editor or notes app and paste it whenever you need it. Some people save a single degree symbol in a blank cell at the edge of their spreadsheet as a permanent reference they can copy from.
Using Find & Replace to add the symbol to existing numbers
If you already have a column of numbers and want to add the degree symbol to all of them at once, Find & Replace is faster than editing each cell individually. First, copy a degree symbol to your clipboard using one of the methods above. Then press Ctrl+H (Windows) or Command+H (Mac) to open Find & Replace.
In the Find field, type the number you want to replace (for example, 32 if you're converting Fahrenheit temperatures). In the Replace field, type the same number followed by a space and the degree symbol you copied. Click Replace All. Excel will add the symbol to every matching number in the spreadsheet. This method works best when the numbers you're modifying are unique or appear in a specific column, so you don't accidentally replace numbers elsewhere in the sheet.
Typing the symbol in formulas and cell references
The degree symbol can appear in cell content (the text or numbers you see in a cell) but not in cell references or formula names. If you're building a formula, you can include the degree symbol in text strings by typing it directly into the formula bar using the same keyboard shortcut or by copying and pasting it.
For example, you could write =A1&"°" to combine a number in cell A1 with the degree symbol, or ="Temperature: "&B2&"°C" to create a label. The symbol appears in the cell result, not in the formula itself. If you're using the symbol only for display and not for calculations, this approach keeps your data clean while showing the symbol to anyone reading the spreadsheet.
Frequently Asked Questions
Why doesn't Alt 176 work on my Windows laptop?
Your keyboard likely doesn't have a dedicated numeric keypad. Look for a Num Lock key, usually near the top right of the keyboard. Press it to set up the hidden numeric keypad on your letter keys, then try the Alt code again. If Num Lock doesn't work, use the Insert Symbol dialog instead.
Can I create a keyboard shortcut for the degree symbol in Excel?
Excel doesn't have a built-in way to create custom keyboard shortcuts for symbols. However, Windows users can use AutoCorrect: go to File > Options > Proofing > AutoCorrect Options, then add a shortcut like "deg" that automatically becomes the degree symbol when you type it and press space.
Does the degree symbol work in formulas and calculations?
The symbol is purely visual and doesn't affect calculations. If you type 32° in a cell, Excel treats it as text, not a number. Use the symbol only for display purposes, and keep actual numeric values in separate cells for math operations.
What if I need the degree symbol but my keyboard layout is different?
The Insert Symbol dialog works on any keyboard layout. The Alt code method (Windows) and Shift-Option method (Mac) are built into the operating system, not the keyboard layout, so they work regardless of whether your keyboard is QWERTY, AZERTY, or another layout.