Select the cell in which you want to insert the degree symbol.Let’s get started! Using a Keyboard Shortcutīelow are the steps to type the degree symbol in Excel using a keyboard shortcut: The method you choose would depend on how you are using the degree symbol in your work.

In this tutorial, I will show you these easy ways to do it (including a keyboard shortcut).

BONUS: Using VBA to Add Degree Symbol to Numbers.

From these four above explained methods (Type degree sign using CHAR function, Use keyboard shortcut for degree symbol, Insert degree symbol using Symbol dialog box, Insert degree symbol using the AutoCorrect feature), You can try any method you want for inserting degree sign in Microsoft Excel cell. Thus, you can see how simple is to insert degree symbol in Excel 2016 / 2013 / 2010. It means if you want to insert degree symbol in Microsoft Word or Microsoft PowerPoint, this setting will work there too. One thing which you need to keep in your mind is that the AutoCorrect feature is case sensitive so if you enter ZDT in lowercase like zdt, it will not get converted into the degree symbol.Īnother thing which you need to know is that the change will be applied to all the Microsoft Office application like Word, PowerPoint etc.

Now, whenever you will type the text ZDT in Microsoft Excel, it will automatically get converted into the (°) degree symbol. Note: Here, you can type degree symbol using the keyboard shortcut ALT 0176, or copy paste it from a cell.įinally, click on Add and then OK button. In the Autocorrect dialogue box, enter ZDT in Replace input box and a Degree Symbol (°) in With input box. On the Excel Options dialogue box, select Proofing > Autocorrect Options… For the example: if you will type ZDT in Excel cell, Excel will automatically replace it with a degree symbol.īut before using this AutoCorrect feature, you need to set the key sequence and here are the steps: You can use the AutoCorrect feature of Microsoft Excel to insert degree symbol.ĪutoCorrect option in Excel allows you to set a specific key sequence for quickly inserting any symbol. We are quite sure that you are going to love this method. You might also like to see: How to Make Symbols with Keyboard on Facebook Method 4: Insert Degree Symbol using AutoCorrect Option in Excel

Degree symbol in excel shortcut keys