It’s often useful to work with a degree symbol. There are multiple ways to do it. Let’s learn how to insert degree symbols in Microsoft Excel.
How to Insert Degree Symbols in Excel (With Key Commands)
Imagine you’re talking about a temperature of 72 degrees. Or about a 60-degree angle. You might find it useful to type these as 72° or 60°.
If you’re working in Excel, you can add the degree (°) symbol by using your keyboard. To begin, go ahead and type a number into a cell. Let’s use 72 as an example.
Next, your key command will be dictated by whether you’re working on a Mac or PC. On Mac, press and hold Shift > Option > 8. You’ll see Excel immediately insert the degree symbol.
On a PC with Windows, the process is similar, but the key command is different. There, the command is Alt > 0176. Keep in mind, you’ll need to use the numeric keypad, not the row of numbers across the top.
If you don’t have one of those, many laptops have a numeric keypad built in. Look for it on the right side of your keyboard, where small numbers are printed on letter keys. These are accessed by holding down the Function (FN) key.
How to Insert Degree Symbols in Excel (With the Insert Menu)
Excel also has a built-in symbol library. With a cell selected, go to the Insert tab on the ribbon, then click on the Symbols button. Choose Symbol, then click the tiny icon in the upper right of the dropdown menu. You’ll see a new array of options appear.
The easiest way to find the degree symbol is to type degree into the Search box and hit Enter. You’ll see the symbol appear, and you can double-click it to insert it into your cell.
As you can see, Excel offers several ways to quickly insert degree symbols.