How to Insert a Degree Symbol in Excel? Very Easy Method
In this article, you will learn about how to insert a degree symbol in Excel spreadsheet. When working with data that includes angles, temperature readings, or any other measurements involving degrees. A degree sign is essential to accurately represent these values. Excel offers various formatting options to enhance the clarity and professionalism of your data, and adding the degree symbol is one of them.
The degree symbol (°) signifies degrees of arc or temperature units, adding precision and clarity to your numerical values. By incorporating the degree symbol into your Excel spreadsheets, you can ensure that your data is presented accurately and professionally.
How to Insert a Degree Symbol in Excel?
Below are the steps to add the degree symbol in Excel datasheet. The above screenshot also helps you in adding degree sign in Excel sheet.
- Open Your Excel Spreadsheet:
Launch Microsoft Excel and open the workbook containing the data where you want to insert the degree symbol. - Select the Cell:
Click on the cell where you want to add the degree symbol. If you’re entering text or numerical values, make sure the cell is selected. - Choose the Insert” Tab:
At the top of the screen click on the “Insert” tab on the Excel ribbon. - Click on “Symbol”:
Click on the “Symbol” option to open the “Symbol” dialog box. - Select the Degree Symbol:
In the “Symbol” dialog box, browse through the available symbols until you find the degree symbol (°) and select it. You can also use the “Font” dropdown menu to select the appropriate font if needed. - Click on “Insert” button:
Once you’ve selected the degree symbol, click the “Insert” button to insert the symbol into the selected cell. - Close the Symbol Dialog Box:
After inserting the degree symbol, you can close the “Symbol” dialog box by clicking the “Close” button. - Verify the Degree Symbol:
Check the cell where you inserted the degree symbol to ensure it appears correctly.
How to Insert a degree symbol by using a keyboard shortcut?
- Place the cursor where you want to insert the degree symbol.
- On your keyboard, select the location where you want to insert degree sign.
- Press Alt + 0176 from keyboard
This method used only for computer having numeric keypads (0-9 keys) keyboards.
By following the above steps, you can easily add the degree symbol (°) to your Excel cells, allowing you to accurately represent angle measurements or temperature readings within your data.
