• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

F9 Calculate

L

leimst

Member
Hello,


Is there a keystroke I can use to return a cell's display to the original formuala after pressing F9 and getting Excel to show me the results of the formula? After hitting F9, I've not been able to figure out how to revert back to be able to view my formula once again.


Thanks in advance,


Leimst
 
Hi Leimst ,


If you mean pressing F9 after pressing F2 , then just pressing the ESCAPE key will return the cell contents to their original formula.


Narayan
 
Thank you both and that did it! I wasn't using the F2 key so that is handy to know as well. I was actually placing my cursor up in the formual bar and then pressing F9 and clicking on the Checkmark which apparently converts it to display the results. I now see that Control Z reverts it back regardless what action I've taken while ESC reverts it back as long as I haven't clicked the checkmark or otherwise left the formual bar area.


Thanks again for the great help! Something else to add to my toolbox! :)


Leimst
 
You must log in or register to reply here.
Back
Top