write degree symbol symbol in ms excel Archives

You can Type a Degree Symbol in a Microsoft Excel file/Sheet with your keyboard. But you have to follow some methods Like- Keyboard Codes, With Excel Menu options, or Mouse methods. We simplify all methods here just read and insert Degree Symbol on your Excel 365, Microsoft Excel 2007/09/10/13/16/19/21, etc.

Excel is the most important software to do personal or commercial professional-related work. That’s why the Degree symbol is the most important symbol for students, researchers, professionals etc.

Using Keyboard Codes Shortcut:

If you want to insert a Degree symbol with your Keyboard then follow this Keyboard Codes Shortcuts.

Step 1: Place the mouse cursor or select the cell where you want to Insert the Degree symbol.

Step 2: Press “F2” to get into Edit Mode.

Step 3: Then type “ALT+0176” Alt codes and release these buttons.

Step 4: After pressing Alt Code Work Done. You can see the Degree Symbol on Excel Cell.

This method is for Windows users. You always remember one thing: these methods only work when you have the numeric key on your keyboards.

Methods for Mac Users:

Step 1: Select the Excel cell where you want to Insert the Degree symbol.

Step 2: Just press the “option+Shift+8” Key.

Copy & Paste Method:

I Like this method. Because You don’t have to remember Alt Codes or Shortcut keys. Just Copy and paste it.

If you have an Internet connection Just Visit our Degree symbol Sign home page. And Click on The “COPY” button. And Done. Now your degree symbol is copied and pasted wherever Excel you want.

More Related Post:

Using CHAR Formula Method:

We all know Excel is famous for Formulas. If we want to save time then we have to use MS Excel Formulas.

For Degree Symbol excel also has a good easy Formula.

Step 1: Select and Click on the Excel cell where you want to Insert the Sign.

Step 2: type =CHAR(176) and enter. Then you can see the Degree symbol.

if you want to write like 360° or 90° then you just have to add “=” first then “&” symbol between the number and degree CHAR formula.

Let’s see how to write the CHAR formula for this type of Degree Symbol.

For example, if you want to insert 90° in a Cell, You can follow the below formula.

Step 1: Select and Click on the Excel cell where you want to Insert the Sign.

Step 2: type =90&CHAR(176) and enter. Then you can see the Degree symbol with 90. and Output will be 90°

Type a Degree Symbol in Microsoft Excel with Menu options Method

First Select and click in a cell box or placeholder where you want to insert the degree Sign.
Click the Insert tab in the Ribbon.
In the Symbols group, click Symbol(Ω). A drop-down window menu pops up.
Click More Symbols. A dialog box appears on the screen.
Select (normal text) from the Font drop-down menu.
Select Latin-1 Supplement from the Subset menu.
Click the degree symbol(°).
Click Insert.
Click Close.

I hope now you can easily write a Degree symbol on any Excel cell. If you face any problems please let us know. I hope you like these methods and now you are able to write/type/insert Degree Symbol on MS Excel. Please let us know if you are facing any problems writing a Degree symbol. We are here to help you.