3 ways to insert the degree symbol in Excel

Do you need to insert the degree symbol into an Excel spreadsheet? There are a few different ways that you can do it. This post explains to you how to insert symbols in excel using the Symbol dialog box, the keyboard shortcut and the Character code.

Suppose you have a temperature data in your report. You need to add degree symbol to the temperatures.

Insert the degree symbol in Excel using the keyboard

Using the keyboard choices in Excel has a lot of benefits. You may be able to work more quickly and effectively, which is one benefit. You may save time by not having to look up popular instructions in menus if you are familiar with the shortcut keys for them.

Please follow the below steps to insert the degree symbol in excel using the keyboard

Make sure that your Num Lock key is turned on.

1. Go to cell B1
2. Press and hold down the Alt key
3. While you are holding down the Alt key, type 0176 on the numeric keypad

Once you release the Alt key, the degree symbol will appear.

Insert the degree symbol in Excel using the symbol menu

Another way to insert the degree symbol is to use the symbol menu.

1. Go to cell B3
2. Click on the Insert tab
3. Click on the Symbols icon. This will open up the Symbols menu.

4. Select the degree symbol and click on the Insert button.
5. Close the symbols dialog box

Insert the degree symbol in Excel using the character code

This method is the same approach as using the symbol icon. Instead of selecting the image icon. you have to use Character code. 00B0 is the character code for the degree symbol.

1. Go to cell B4
2. Click on the Insert tab
3. Click on the Symbols icon. This will open up the Symbols menu.

4. Type the code 00B0 in the Character code input box and click on the Insert button.
5. Close the symbols dialog box

Conclusions

The degree symbol is a handy way to add emphasis or visual interest to your Excel spreadsheet. You can insert the degree symbol in Excel by using the Symbol dialog box, the Character Map, or the keyboard shortcut. With a little practice, you will be able to insert the degree symbol in Excel quickly and easily.