How to get Excel out of Select Cell mode

Looking for a tip on Microsoft Excel (2003):

If you click on a cell containing a formula, click into the formula, and click away, Excel will enter the cell or range you next select into the formula at the cursor. This is fine and dandy a lot of times, but right now I am working with a spreadsheet that has a lot of really long formulas. If I click into a cell and it goes into the state where it wants to enter a reference to the next cell I click into the formula, I can't always get out of it, and if I click on something, I don't always even know what the change was (these are really long formulas).

So my question is, is there a keystroke I can press or some other action to immediately get out of "input the next thing you click" mode and be sure there are no side effects? Ctrl-Z doesn't do it.

3

3 Answers

Hit Esc or Enter I believe.

3

Hit the escape key.

Ctrl + Enter

... at least, that’s the answer as far as my understanding of your question goes:

… to immediately get out of “input the next thing you click” mode and be sure there are no side effects?

, which is rather vague.

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy