If you are saying that you are using F9 for looking at the values of parts
of a formula in the Formula Bar, and you want to retain the formula when you
are done, the key thing is to press Esc, not Enter, when you are done
looking at the values.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.