Now whenever you enter this text DEGSYM in a cell in excel, it will automatically convert it into the degree symbol.Unfortunately, its not as straightforward as you want it to be.Dont worry There are plenty of ways to insert or type a degree symbol in Excel.This Tutorial Covers: Inserting Degree Symbol in Excel Using a Keyboard Shortcut Copy Paste the Degree Symbol Using the CHAR Formula Using the Insert Symbol Dialog Box Using Autocorrect in Excel BONUS: Using VBA to Add Degree Symbol to Numbers Inserting Degree Symbol in Excel In this tutorial, I will show you these easy ways to do it (including a keyboard shortcut).
The method you choose would depend on how you are using the degree symbol in your work. ![]() Use the keyboard shortcut ALT 0176 (you need to hold the ALT key and then press 0176 from the numeric keypad of your keyboard). Note: This keyboard shortcut works only if you have a 10 keys numeric keypad in your keyboard. If you dont have a numeric keypad, you need to enable the Num lock first and then use this keyboard shortcut. ![]() You can simply copy the already inserted degree symbol and paste it. Copy Paste the Degree Symbol You can copy and paste the degree symbol in Excel. To do this, you first need to copy it from a degree symbol already available in Excel, or you can copy it from any web page from the internet. Below is the degree symbol from which you can copy: Using the CHAR Formula You can use the CHAR(176) to get the degree symbol in a cell in Excel. To do this, enter CHAR(176) in a cell and press enter and it will return the degree symbol as the result. You can also use this formula with other text strings or formulas to add the degree symbol to it. For example, if you want to have 48 in a cell, you can enter the below formula 48CHAR(176) Similarly, you can combine it with a cell reference. For example, if cell A1 has the value 48, then you can use the formula A1CHAR(176), and it will give you 48 as the result. Using the Insert Symbol Dialog Box There is a Symbol dialog box in Excel that allows you to insert symbols such as degree, cent, delta, etc. Here are the steps to insert the degree symbol using the Insert Symbol dialog box: Click on the Insert Tab in the ribbon. In the Symbols dialog box that opens, select the font in which youre already working. Scroll down, find and select the degree symbol (you may have to spend some time looking for the degree symbol). Click on Insert. This will insert the degree symbol in the cell in Excel. Outlet Symbol For Excel Code To TheIt enables you to assign a code to the degree symbol (such as DEGSYM).
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |