<div>
not direct answer, but .. :)<br />
you can check results of formula also in Formulas&gt;Evaluate formula. I do not know if you know this, but maybe this will be equivalent solution for you to see formula result and this does not change formula to value<br />
<br />
If there is opposite action to F9 I am not sure, I never hear aboout it, and also Office help does not say anything about it:<br />
<a href="http://office.microsoft.com/en-001/excel-help/excel-shortcut-and-function-keys-HP001111659.aspx" rel="ugc">http://office.microsoft.com/en-001/excel-help/excel-shortcut-and-function-keys-HP001111659.aspx</a>
</div>


not direct answer, but .. :)
you can check results of formula also in Formulas>Evaluate formula. I do not know if you know this, but maybe this will be equivalent solution for you to see formula result and this does not change formula to value

If there is opposite action to F9 I am not sure, I never hear aboout it, and also Office help does not say anything about it:
http://office.microsoft.com/en-001/excel-help/excel-shortcut-and-function-keys-HP001111659.aspx [http://office.microsoft.com/en-001/excel-help/excel-shortcut-and-function-keys-HP001111659.aspx]

<div>
@ All&lt;br /&gt;&lt;br /&gt;Thank you!&lt;br /&gt;&lt;br /&gt;~ Geekamo
</div>


@ All<br /><br />Thank you!<br /><br />~ Geekamo

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I just learned that when pressing F9, while selecting part of a formula is results in the answer. &nbsp;I love this cause I can now easily see what each piece of my formula is resulting too. &nbsp;But, how do I go back to the normal formula? &nbsp;Anytime I press F9 to see the result, I have to either ESC out of the formula, or cell on a cell. &nbsp;Is that the only way to get back? I assumed F9, would be like a toggle, but I guess not.<br />
<br />
~ Geekamo
</div>
</div>


Hello Experts,

I just learned that when pressing F9, while selecting part of a formula is results in the answer.  I love this cause I can now easily see what each piece of my formula is resulting too.  But, how do I go back to the normal formula?  Anytime I press F9 to see the result, I have to either ESC out of the formula, or cell on a cell.  Is that the only way to get back? I assumed F9, would be like a toggle, but I guess not.

~ Geekamo

F9 Shortcut

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.