Hold down the “Alt” key with your left hand and enter “0176” on the digital panel at the same time. You should see the degree symbol in the cell. Step 3įind the “Alt” key on your keyboard.
Turn on the keypad lock function by pressing the “Number Lock” button. You can only enter the degree symbol using the number pad (not the number line above the letters.) Step 2Ĭlick in the cell where you want to enter the degree symbol. For example, the =CHAR(176) formula returns the equivalent character (a degree symbol in this case) for selected font type.Use the “Alt” key to insert ASCII or Unicode characters. The CHAR function simply converts numeric codes into the equivalent ANSI character. When holding the Alt key, press 00B0 (the same code from the previous method) in the Symbol dialog. Since the check mark is a symbol that doesn't exist in all font families, you need to set up the required font first. All you need to do is to hold the Alt button, and type in the code.
You can enter any special character by typing in the corresponding code. You can find the degree symbol in this menu.Īlternatively, after selecting the font, you can type 00B0 into the Character code box. In the Symbol dialog, choose your desired font, and then select Latin-1 Supplement from the Subset dropdown. You can find the Symbol dialog by going to INSERT > Symbols > Symbol in the Ribbon. Copy & Paste the character below:Įxcel (just like Word) has a Symbol feature where all supported characters are listed. Let's start with the easiest way to add a degree symbol in Excel. In this article, we're going to show you 4 different ways on how to insert a degree symbol in Excel. However, standard keyboards don't have a button for this useful symbol. The degree symbol (°) typically indicates temperature measurement, the magnitude of angles in geometry, and diminished chords in music.
0 kommentar(er)
