FREE Excel Tips Newsletter from
Subscribe here to get more tips like this every week

Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

October 18, 2016

Hi fellow Excel Addict,

Francis Hayes (The Excel Addict) - Cape to Cabot Race, October 16, 2016, St. John's, Newfoundland, CanadaSo, my first Cape to Cabot race is in the books and what an experience it was. It was very windy and chilly at the start line on Sunday morning, just a few hundred meters from the cold North Atlantic ocean at Cape Spear, the most easterly point of land in Canada.

The cool temps was almost ideal for running. My goal was to finish the 20 kilometer run in under 2 hours, so I was more than happy with my time of 1:53:57.

Although, I had run that last brutal 1.6 kilometers, 'The Munn Mile', (a 150 meter/500 foot elevation gain) up Signal Hill six times over the past two months in training, doing it AFTER just running more than 18 kilometers was way harder than I ever imagined. I did manage to run half and walk half.

Running with more than 400 other enthusiastic runners from (see Google map) one of the most famous historic sites in Newfoundland (Cape Spear) and finishing at another famous historic site (Cabot Tower on Signal Hill) was an awesome experience and something I will remember for the rest of my life.

Enough about me, let's talk Excel.

today's 'Excel in Seconds' tip, I'll show you how to 'How to Insert Degree Symbols in Your Worksheet'.

If you missed last Thursday's 'Excel in Minutes' tip, 'View Data From Separate Areas of the Same Worksheet at the Same Time', you can read it here now.

Please feel free to share my newsletter with your friends — they will thank you for it.

ope you have a great week and keep on Excelling,
Francis Hayes (The Excel Addict)
fhayes[AT] Quote of the Day

"Go fast enough to get there but slow enough to see"

-- Jimmy Buffet --

If you missed my last newsletter, you can click here to view it online.

Excel in Seconds with

How to Insert Degree Symbols in Your Worksheet

If you want to show degree symbols
(e.g. 20C) in your Excel worksheet, you have several options.

Option 1: Enter the degree symbol's character code in the cell

1) Position your cursor in the cell or in the formula bar where you want to insert the degree symbol;

2) H
old down the ALT key and type 0176 (or 248) on your numeric keypad.**

ALT Keys ASCII Code For Degree Symbol in Microsoft Excel 2007 2010 2013 2016 365

Option 2: Use Excel's Insert Symbol Option

1) Position your cursor in the cell or formula bar where you want to insert the degree symbol;

2) From the Insert tab, select Symbol, ensure a standard font is selected, find and click on the degree symbol, click the Insert button, then Close.

Insert Degree Symbol in Microsoft Excel 2007 2010 2013 2016 365
3) Press Enter to complete the entry.

Option 3: Create a custom number format containing the degree symbol

If your worksheet has more than a few cells requiring degree symbols, it's best to create a custom number format that includes the degree symbol (using method 1) that you can apply to any cells you want. That way, you just enter the numbers on your worksheet and they will be automatically be formatted with the degree symbols.

1) Select the cells you want the degree format applied to;

2) Press (keyboard shortcut) CTRL+1 to open the Format Cells dialog, click the Number tab and select Custom;

3) In the Type field enter the desired number format followed by the degree symbol using method 1 (e.g. 0 or 0.0). If you want you can also type  F (for Fahrenheit) or C (for Celsius) following the degree symbol;
Custom Number Format Degrees Symbol in Microsoft Excel 2007 2010 2013 2016 365

4) Press Enter.

** You have to use your numeric keypad NOT the top row of numbers on your keyboard.
Use Numeric Keypad To Enter Alt Codes in Microsoft Excel 2007 2010 2013 2016 365

FREE Excel Tips Newsletter from
Subscribe here to get more tips like this every week

Thanks for supporting this newsletter and website

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630