

You can use the =CHAR(176) to get the degree symbol in a cell in Excel. To do this, you first need to copy it from a degree symbol already available in Excel, or you can copy it from any web page from the internet.īelow is the degree symbol from which you can copy: ° Using the CHAR Formula You can copy and paste the degree symbol in Excel. You can simply copy the already inserted degree symbol and paste it. Once you have typed the degree symbol, you don’t even need to use the keyboard shortcut again and again. If you don’t have a numeric keypad, you need to enable the Num lock first and then use this keyboard shortcut. Note: This keyboard shortcut works only if you have a 10 keys numeric keypad in your keyboard.

Let’s get started! Using a Keyboard Shortcutīelow are the steps to type the degree symbol in Excel using a keyboard shortcut: The method you choose would depend on how you are using the degree symbol in your work.

In this tutorial, I will show you these easy ways to do it (including a keyboard shortcut). BONUS: Using VBA to Add Degree Symbol to Numbers.
