"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Excel Users Become Local Spreadsheet Experts"

Troubleshoot Long Formulas


How many times have you had long 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 tip I use when working with long formulas.

In the Formula Bar (the white area directly above the column headings and to the right of the equal sign) drag the 'I-beam' cursor to select part of the formula. Then press F9.

When you do this, only the selected portion of the formula is evaluated. This will help you determine which part of your formula is the problem.

IMPORTANT! When you're done, remember to hit 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. You'll have to use Edit, Undo (CTRL+Z) to get back to your original formula.


Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.