Microsoft Office Development and Consultancy
|Excel > Formulas > Evaluating Formulas||< Previous | Next >|
Evaluating parts of your formulas
You can use the F9 key to evaluate parts of your formulas. Highlight the portion of the formula that you want to resolve and press the F9 key.
Always press the ESC key afterwards. Be careful not to press the Enter key as this will result in your formula being permanently changed. This can be used to see the values that a range is actually returning.
can you F9 whole functions to replace the results ??
|© Better Solutions Limited 06-Dec-2013||< Previous | Top | Next >|