Excel Tips and Tricks : Insert Degree Symbol in Excel

Table of Contents

The Degree Symbol

A degree symbol is a small raised circle that is used to represent degrees of temperature, latitude, longitude, or angles.

It is also used in mathematical expressions to represent degrees of freedom.

The degree symbol is usually placed after the number it modifies. F

or example, if you wanted to write “5 degrees Celsius” you would write “5°C.”

The degree symbol is part of the Unicode character set and can be generated on a computer by using the Unicode character code.

For example, the code for the degree symbol is “00B0”.

To insert the degree symbol into a document, you can use the symbol’s character code or the degree sign shortcut.

The degree symbol is also used in conjunction with other symbols to represent various units of measurement.

For example, the “°” symbol is often used with the “F” symbol to represent degrees Fahrenheit. When used in this way, the degree symbol is called a caret.

Excel Degree Symbol : The simple way

To insert a degree symbol in Excel, simply press SHIFT + 8 (on a Mac, use Shift + Option + 8).

The degree symbol will appear wherever your cursor is located.

You can also use the Insert Symbol dialog box to insert the degree symbol.

Excel Degree Symbol : The advanced way

If you want to insert a degree symbol in Excel, there are a few different ways you can do it.

One way is to use the Symbol dialog box:

Select the cell where you want to insert the degree symbol.
On the Insert tab, in the Symbols group, click Symbol.
In the Symbol dialog box, click the Symbols tab, click the Special Characters tab, and then scroll down to the degree symbol.