FREE CHEAT SHEET & VIDEO
Watch the video to see it done and download a printable PDF cheat sheet of all the key steps
PLUS, COLLECT OUR 30 EXCEL POWER TIPS FOR FREE
Enter your details for immediate access
I’m often asked how you get a degree symbol in Excel. Well it’s actually pretty simple. There are 3 ways.
Let’s say you want to display 180o.
NB. You can expand the dialog by hovering over the dialog frame and with the double-headed arrow click-and-drag to the size you require.
The superscript can be used for other things. For example, if you’re laying some concrete or turf and you want to record the area to be covered, let’s say it’s 20 square meters, you can display it as 20m2.
Another common application of superscript is when you need to display a particular date format like 6th June.
Subscript does the opposite to superscript. The text is little and sits below the baseline.
For example, the chemical symbol for water - H2O. That 2 actually sits below the baseline. To do that, you
Every character (letter, number or symbol) has what’s called an ASCII code (American Standard Code for Information Interchange). I won’t bore you with the history but here is a list of useful ALT Codes you can use in Excel to get started.
The ALT Code for a degree symbol is 0176. Here’s how you enter it in Excel.
That’s it. I hope this short post has been useful.
Did this clear something up for you? If so, please share on your socials and/or post a brief comment below.
Likewise, if something didn't make sense or you have a question, pop it into the comments below. I'll be waiting ...
Cheers. Here's to your learning and success. Enjoy the rest of your day.
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.