Excel 2000, 2002, 2003, 2007 Tips

The Excel Addict - Help with Excel 2007

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.

Greetings from The Excel Addict

Hi fellow Excel Addict,

Francis Hayes (The 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.

Update your profile hereOh! 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...

  • Please type 'The Excel Addict' in the Subject field of your emails.

  • If you reply to this email, please delete the newsletter content before Sending.

  • Remove background color in Outlook 2007 - Options, Page Color, No Color.

  • View The Excel Addict Francis J Hayes's profile on LinkedIn   Find out what The Excel Addict is doing NOW

    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.  

    Quote of the Week:

    "Our environment, the world in which we live and work, is a mirror of our attitudes and expectations." -- Earl Nightingale  (author of The Strangest Secret)

    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.

    Microsoft Excel Tip #1

    Quickly Identify Your Conditionally Formatted Cells (XL2003/XL2007)

    If 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?

    Not a problem!

    There is an easy way to identify cells that have Conditional Formatting applied. press the F5 key and click the Special button at the bottom of the Go To dialog. When you click the Conditional Formats option, another option (All, Same) becomes available.

    Identify Conditional Formats in Excel 2007

    To identify which cells have Conditional Formatting the same as the currently Active Cell, click Same and OK. All cells on the worksheet that have the same Conditional Formatting will be selected. You can now easily make changes or select additional cells to apply the formatting to.

    Instead of selecting the Same option, All will help you identify all cells in your worksheet containing Conditional Formatting.

    Pull answers from your lists with these 45 LOOKUP formulas

    Microsoft Excel Tip #2

    Show Degree Symbols In Excel (XL2000-XL2007)

    If you need to show temperature data in your worksheet with degree symbols (e.g. 20C), 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.**

    If you cannot get the ALT code to work, here's another option for inserting the degree symbol.
    From the Insert tab/menu select Symbol, choose a font (e.g. Arial), find and click on the degree symbol, click Insert and Close.

    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.

    Show degree symbols in your Excel worksheet by using an ALT code in a custome number format

    ** 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.

    101 Excel Tips revealed in this book
    Microsoft Excel 2003

    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.

    Non-Excel Tip

    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

    Save Outlook email messages as text files

    My goal: To reach One Million Excel Users

    Subscription Information

    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