Publication Date: June 23, 2010
This newsletter is being sent to 16,000+ Excel 'addicts' around the world
using Aweber, the best solution for managing your email campaigns.
If you having trouble displaying graphics in this email, I have
posted an online HTML version of this week's newsletter here.
Hi fellow Excel Addict,
I hope you're having a great week!
Are you a soccer/football fan? Have you been following the World Cup? Like most working people in North America, because of the time difference, I don't get to see many games live on TV, so my only option is to watch the replays at night. I love soccer but I'm not a fanatic (or an addict), so I don't really have a favourite team. What about you? Do you have a favourite team? Who do you think will make it to the final? Who do you think will be crowned as the new world champions?
While South Africa is in the middle of winter (nothing compared to a Canadian winter), summer has F-I-N-A-L-L-Y arrived in Canada, so it's nice to get outside in the garden and enjoy the warm sunshine. Due to a knee injury from this past winter that won't go away, I've taken up biking this summer instead of running. People keep telling me that's what happens when you get old. Waddaya mean old?! I still feel as young as I did 30 years ago - except for my $%#@* knee.
Oh! Here is something that I have been meaning to mention to you for months. Every week I get several requests from readers to update their email address in my database. And I fulfill each request immediately before I forget (another sign of getting old?). It's not a big deal for me but I do have to log into my account, search for the old address and change it.
I just want to let you know that there's a much easier and quicker way to update your own profile. At the very bottom of every newsletter there is a link that you can use to access your profile and make the changes you want - and it only takes a couple of seconds.
Enjoy the weekend!
Francis Hayes (The Excel Addict)
If you want to send me an email...
This week's tips..
1) Quickly Identify Your Conditionally Formatted Cells (XL2003/XL2007)
2) Show Degree Symbols In Excel (XL2000-XL2007)
3) Save Multiple Outlook Messages As A Single Text File
If you're having trouble displaying graphics in this email, I have posted an online HTML version of this week's newsletter here.
Last week's tips were...
1) Identify Your Input Cells (XL2000-XL2007)
2) Create Custom Default Worksheet And Workbook Templates (XL2003/XL2007)
3) How To Drag and Drop Files To Open Them
You can still find last week's newsletter here.
You can access even more tips on my website by going to my members' page.
CAUTION: Make sure you save a copy of your spreadsheet before trying these tips,
just in case you make an error or the procedure doesn't produce the results you want.
Quickly Identify Your Conditionally Formatted Cells (XL2003/XL2007)
you're a fan of Conditional Formatting you likely have struggled with
this little issue. Once you have applied Conditional Formatting to a
range (or ranges) of cells you may have needed to go back later and
make changes to the formatting or the condition used. You need to make
the change to all the cells you previously formatted, but how can you
tell which cells have Conditional Formatting?
Show Degree Symbols In Excel (XL2000-XL2007)
If you need to show temperature data in your worksheet with degree symbols (e.g. 20°C), Excel gives you several options. Here are two of the easiest ones.
Option 1: Enter the degree symbol's character code in each cell
As you are typing your data, hold down the ALT key and type 248 or 0176 on your numeric keypad.**
cannot get the ALT code to work, here's another option for inserting
the degree symbol.
Option 2: Create a custom number format containing a degree symbol
By creating a custom number format that includes the degree symbol (using method 1), you will just need to enter the numbers on your worksheet and degrees symbol will be displayed.
1) Select the cells you want the degree format applied to;
2) In Excel 2007, on the Home tab click the small arrow on the bottom right of the Number group, and select Custom;
In Excel 200-2003, from the Format menu select Cells, click the Number tab and in the Category list 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.
Many people have asked me how to type character codes using a laptop
keyboard, since it doesn't have a separate numeric keypad. On my laptop
(Thinkpad) I press Shift+NumLk
to turn on the keypad. I then type the character code (ALT+248) and press Shift+NumLk to turn
off the keypad. Other laptops may require pressing different keys.
Try out the secrets in my ebook
for two months. If
they don't save
you 10 times the price of the book... If you're not 100% satisfied... ...simply request a full refund
from ClickBank.com There's absolutely no risk to you.
Try out the secrets in my ebook
for two months. If
they don't save
you 10 times the price of the book...
If you're not 100% satisfied...
...simply request a full refund
There's absolutely no risk to you.
Save Multiple Outlook Messages As A Single Text File
Here's a Microsoft Outlook tip that you may find useful. If you want to backup or save multiple email messages from Outlook, it's simple.
Select the messages you want to save into a single text file, click File, Save As and give the text file a name.
I find this great for combining multiple related emails into a single text file that I can edit or keep for future reference. Then I can delete those emails
Spreadsheet Tips From An Excel Addict is available only to subscribers of my newsletter.
If this newsletter was forwarded to you and you would like to get your own copy, please visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber(DOT)com
If you would like to share this newsletter with others...
1) Forward this newsletter by email, but first delete the unsubscribe link at the very bottom so you don't get accidentally unsubscribed
2) Ask your friend/colleague to visit TheExcelAddict.com or send a blank email to theexceladdict(AT)aweber(DOT)com
3) Post a link to TheExcelAddict.com in a company newsletter or website
|"Spreadsheets Tips From An
Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630