How To Insert Degree Symbol In Excel

Take you e'er encountered a problem with inserting a degree symbol into your excel certificate? To new excel users, they may scratch their heads as they effort to figure out options to insert the degree symbol. Nonetheless, adding the degree symbol into your document is a very pretty elementary matter.

Here are some of the ways you tin can use to add together the degree symbol into your Excel certificate.

Using CHAR formula

The CHAR formula tin can exist used to add different symbols to your document. Below are the steps to add a caste symbol using this formula.

1. Click the cell you want to insert the degree symbol.

ii. And then, type this =CHAR(176), then hit the enter push button. By doing so, the degree symbol appears on the cell selected.

iii. Also, you can use this formula together with other strings. For example, let say you want to add the caste symbol next to a word or number like 23˚

Using the Symbol dialogue box

This is another way to insert the degree symbol into your certificate. Here are the steps involved in this method;

1. On the Excel principal page, click on the cell you want to insert the symbol.

2. So on the top bars, locate and click on the "Insert" tab. From the Insert tab, locate the "Symbol" icon within the Text section. Click on information technology.

3. From the dialogue box, locate the RING In a higher place section. Type the Character code equally "02DA", and and so set the "From" carte du jour as "Unicode(hex)."

4. Finally, click the insert push button, and the symbol will be added to the selected jail cell.

Using the copy and paste method

You can also get the degree symbol from another source and paste it into your Excel document.

Steps;

1. From the other source, this could exist any other Microsoft certificate or from the webpage, highlight the caste symbol and copy information technology. you can copy using the keyboard shortcut (Ctrl + C).

2. So open the Excel document you're working on.

three. Select the jail cell you lot want to add the degree symbol, so paste it there. You can do this by pressing Ctrl + V on your keyboard.

Using keyboard shortcuts

You tin can also add together the degree symbol using keyboard key combinations. However, this method doesn't work on all keyboards. It only works where your keyboard has a numeric keypad.

Steps;

one. Select the prison cell yous want to add the symbol.

ii. Then, press F2 to enter into the edit mode.

3. Then, on your keyboard, press Alt + 0176.