October 18, 2016
Hi fellow Excel Addict,
So, 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.
In 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.
Hope you have a great week and keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
How to Insert Degree Symbols in Your Worksheet
If you want to show degree symbols (e.g. 20°C) 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) Hold down the ALT key and type 0176 (or 248) on your numeric keypad.**
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.
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;
4) Press Enter.
** You have to use your numeric keypad NOT the top row of numbers on your keyboard.
| 'Spreadsheets Tips
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