Excel 2000, 2002, 2003, 2007 Tips

The Excel Addict - Help with Excel 2007

Publication Date: February 17, 2010

This newsletter is being sent to 14,000+ Excel 'addicts' around the world
using Aweber, the best solution for managing your email campaigns.  

Greetings from The Excel Addict

Hi fellow Excel Addict,

Have you been watching the Winter Olympics from Vancouver? If you've been reading or listening to all the critisism from the media about these Olympics, you are being seriously misled. Just ask Lindsey Vonn, Alexandre Bilodeau, Hannah Kearney, and Maelle Ricker how they feel about the 2010 Olympics.

Vancouver isn't the only place having unprecedented weather this winter. Just ask the people living around Washington DC. Even here in eastern Newfoundland, for the most part, we have had very little snow this winter compared to other years. However that may be about to change. For the third Friday in a row, we are facing a major snow storm. A 'snow day' on a Friday is a gift, but three Fridays in a row? What did we do to deserve this? (I'm only half joking.)

Keep on Excelling,
Francis J Hayes (The Excel Addict)

Please type 'The Excel Addict' in the Subject field of your emails.
If you reply to this message, please delete the newsletter content
below before sending. To remove the background color in
Outlook 2007, click 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) Formula Troubleshooting Trick (XL2000-XL2007)
2) Insert Line Breaks To Make Complex Formulas Easier To Read (XL2000-XL2007)
3) Group Or Ungroup Your Taskbar Buttons? (WinXP)

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) Print Pages In Any Order You Want - Part 2 (XL2003/XL2007)
2) Inserting A New Sheet Should Be This Simple (XL2000-XL2007)
3) Getting Better Google Results

You can still find last week's newsletter here.

You can access even more tips on my website by going to my members' page.  

"Perfection is the lowest standard of achievement. Doing is the highest.” -- Andy Jenkins (Internet Marketer)

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

Formula Troubleshooting Trick (XL2000-XL2007)

How many times have you had long, complex formulas that didn't give you the answer you were looking for? Sometimes it can be difficult to determine where the problem is. Here's a neat trick that will help you determine which part of your formula is causing the problem.

1) Select the cell containing the formula;

2) In the Formula Bar, click and drag the 'I-beam' cursor to select part of the formula;

3) Press the F9 key. When you do this, only the selected portion of the formula is evaluated. 

Calculate part of a formula with F9

IMPORTANT! When you're done, remember to press the ESC key to get your original formula back. If you accidentally press Enter, your formula will now include the evaluated portion as a fixed value. If that happens Undo (CTRL+Z) it to get back your original formula.

Pull answers from your lists with these 45 LOOKUP formulas

Microsoft Excel Tip #2

Insert Line Breaks To Make Complex Formulas Easier To Read (XL2000-XL2007)

As you know, in Excel, you can get very creative with formulas and do things most users would never have thought possible. One of the drawbacks of complex formulas is that they are often difficult to understand - especially when you go back and look at them long after they were originally created.

Create nested if formulas in Excel

Did you know you can make your complex formulas easier to read by breaking each section onto a separate line? Yes, you CAN insert line breaks in your formulas - just like you can insert line breaks in text in a cell.
Make formulas easier to read using line breaks in the formula bar
Simply press ALT + ENTER as you are editing your formula to break the next section of the formula to the next line.

Not only does this make your formulas easier to read when you look back at them later but it also makes the process of creating your multi-step formulas much easier.

101 Excel Tips revealed in this book
"I purchased your eBook and so did my boss.  Even though we are both experienced Excel user in the field of engineering and construction surveying, we find that your tips are top-notch and to the point; well above the standard fodder you find in the range of Excel books available on the market. Thank you" -- Richard J., Las Vegas, NV

Click Here to Download Excel Secrets eBook

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.

If you're not 100% satisfied, simply request a full refund from ClickBank.com

Non-Excel Tip

Group Or Ungroup Your Taskbar Buttons? (WinXP)
When you have multiple windows open in the same application, by default, Windows XP will try to save space on the Taskbar by grouping these buttons. To switch to another window in the same application, you have to click the grouped button and choose from the list that pops up.
Some people find this grouping feature useful. Others, me included, prefer to work with separate buttons for each window.

Ungroup your Taskbar buttonsIf your buttons are currently grouped, try ungrouping them and see if you like it.

1) Right-click an empty area of the Taskbar and click Properties;
2) From the Taskbar tab clear the 'Group similar taskbar buttons' option;
3) Click OK.

t a glance you can see which windows you have open and also, when you are working between two windows (i.e. two Excel workbooks), you can quickly toggle back and forth using the familiar ALT+TAB keyboard shortcut.

If you work with many files open at the same time and find that the buttons on the Taskbar are too small to read the descriptions, you can adjust your Taskbar to show the buttons on two rows.

To do this, right-click a blank area of your Taskbar and, from the pop-up menu, make sure the 'Lock the Taskbar' option is not checked. Then, move your cursor to the top edge of the Taskbar until it changes to a two-headed vertical arrow. Now, slowly drag it up until the taskbar takes up two rows.

Expand your Taskbar to display more buttons

Let me know if you like Grouped or Ungrouped Taskbar buttons.

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