The fastest way: copy and paste from the character map

Open Windows Character Map (search "character map" in your Start menu), type "degree" in the search box, and double-click the ° symbol. It copies to your clipboard. Switch to Excel, click the cell where you need it, and paste with Ctrl+V. This takes about 10 seconds and works on any keyboard.

On a Mac, open Spotlight (Command+Space), search "character viewer", find the degree symbol, and double-click it to insert it directly into your Excel cell. No copying step needed — it types straight in.

Key Takeaways

  • The degree symbol (°) can be typed in Excel using Alt+0176 on Windows, or Option+Shift+8 on Mac, without leaving your spreadsheet.
  • Character Map (Windows) or Character Viewer (Mac) lets you search for the degree symbol by name and copy it in seconds if you forget the keyboard shortcut.
  • You can also type the word "degree" in a cell and use Find & Replace to swap it for the actual symbol across multiple cells at once.
  • Creating a custom keyboard shortcut or saving the symbol in your AutoCorrect settings means you never have to remember the code again.

Using Alt codes on Windows

On a Windows keyboard, hold Alt and type 0176 on the numeric keypad (not the number row at the top). Release Alt and the degree symbol appears. This only works on the numeric keypad — the numbers across the top of your keyboard will not work.

If your laptop has no numeric keypad, enable Num Lock and use the keys marked with small numbers (usually on the right side of the keyboard). Some laptops require you to hold Fn while typing the Alt code. If Alt+0176 does not work, try Alt+248 instead — both produce the degree symbol on most Windows systems.

Using keyboard shortcuts on Mac

On a Mac, hold Option+Shift and press 8. The degree symbol types when ready. This is the standard Mac shortcut and works in Excel, Google Sheets, Word, and most other programs.

If that shortcut does not work, your keyboard layout may be different. Open System Preferences, go to Keyboard > Input Sources, and check which layout you are using. British and other non-US layouts sometimes use different key combinations.

Finding and replacing text with the degree symbol

If you have a column with temperatures written as "72 degrees" and need to change them to "72°", use Find & Replace. Open the Find & Replace dialog (Ctrl+H on Windows, Command+H on Mac), type "degrees" in the Find field, and paste the degree symbol in the Replace field. Click Replace All to change every instance at once.

This method is faster than editing each cell individually, especially in large spreadsheets. You can also use it to standardize inconsistent entries — for example, replacing "deg" or "d" with the actual symbol.

Setting up AutoCorrect so you never type it manually

You can teach Excel to type the degree symbol automatically. On Windows, go to File > Options > Proofing > AutoCorrect Options. In the Replace field, type something short like "dg" or "deg". In the With field, paste the degree symbol. Click Add, then OK. Now whenever you type "dg" followed by a space, Excel replaces it with °.

On Mac, go to Excel > Preferences > Authoring and Language Tools > AutoCorrect. Follow the same steps. Choose a shortcut you will not accidentally type in normal work — "dg" works better than "d" because you might type "d" in a word and trigger the replacement.

Creating a custom keyboard shortcut

If you use the degree symbol often, you can assign it a dedicated key combination. On Windows, open Character Map, right-click the degree symbol, and look for a "Shortcut Key" option (this varies by Windows version). Some versions do not offer this feature, so AutoCorrect is usually simpler.

On Mac, go to System Preferences > Keyboard > Text, click the plus sign, and create a new entry. Type the degree symbol in the "Replace" column and your chosen shortcut in the "With" column. This works system-wide, not just in Excel.

Typing the degree symbol in a formula

If you need the degree symbol as part of a formula result — for example, to display "72°F" from a temperature value in another cell — use the CONCATENATE function or the ampersand operator. Type =A1&"°" where A1 contains the number. Paste the degree symbol between the quotation marks, or use CHAR(176) instead: =A1&CHAR(176).

CHAR(176) is useful because you do not have to copy and paste the symbol — Excel knows the character code. This method works the same way on Windows and Mac.

Frequently Asked Questions

Why does Alt+0176 not work on my laptop?

Your laptop may not have a numeric keypad, or Num Lock may be off. Try enabling Num Lock (usually a key labeled Num Lock or Fn+Num Lock), then try Alt+0176 again using the small numbers on the right side of your keyboard. If that still does not work, use Character Map or the CHAR(176) formula instead.

Can I type the degree symbol on a Chromebook or in Google Sheets?

On a Chromebook, press Ctrl+Shift+U, then type 00b0, then press Space or Enter. In Google Sheets, this works the same way. You can also open the Special Characters tool (Insert > Special Characters) and search for "degree" to insert it directly.

What if I need the degree symbol for Celsius or Fahrenheit?

Type the number, then the degree symbol, then the letter: 72°C or 72°F. If you want to automate this, create an AutoCorrect entry for "72c" that replaces with "72°C", or use a formula like =A1&"°C" to add it automatically.

Is there a difference between the degree symbol and the superscript zero?

Yes. The degree symbol (°) is a single character designed for temperatures and angles. A superscript zero (⁰) is a zero raised above the line. They look similar but are different characters. Use the degree symbol for temperatures and measurements.

Can I copy the degree symbol from another cell and paste it?

Yes. If one cell already has the degree symbol, click it, copy (Ctrl+C), click the cell where you need it, and paste (Ctrl+V). This is slower than using a keyboard shortcut or AutoCorrect, but it works if you have the symbol somewhere nearby to reference.