OfficeTips Home || VBA Section || General Section ||  Download Section  ||  Privacy Policy

Troubleshooting a Long Formula

If you create a long worksheet formula that is not returning the expected result, you can drag the pointer to select part of the formula in the formula bar, and then press F9. When you do this, only the selected portion of the formula is evaluated.

Important If you press ENTER, that part of your formula is lost, so be sure to press ESC instead. However, if you mistakenly press ENTER, try pressing CTRL+Z to undo the change.

 

Copyright 1999-2014 (c) Shyam Pillai. All rights reserved.