• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 457
  • Last Modified:

F9 Shortcut

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
2 Solutions
Saqib Husain, SyedEngineerCommented:
You have to ESCape out.
helpfinderIT ConsultantCommented:
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:
Saqib Husain, SyedEngineerCommented:
I stand corrected

Ctrl-z will bring you back
Mind you, control-z only reverses the last F9 action, so if you plan to evaluate more parts, only the last time you hit F9 will be reversed. So Escape is still important.
GeekamoAuthor Commented:
@ All<br /><br />Thank you!<br /><br />~ Geekamo
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now