Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This is driving me absolutely crazy, while I'm in the middle of typing my equations into a cell I like to pre-create the parenthesis sometimes when order of operations is being explicitly set, however if I do =() and then move the cursor back one so it is between the two parenthesis, excel throws a pop up telling me there is an error in my equation, I am not done yet obviously but it's easier for me (as a human) to create the start and end parenthesis first rather than figuring out where the ending ones go once all the starting ones are done. Anyone know how I can turn off this stupid pop-up so I can just write my damn equation?

share|improve this question
up vote 3 down vote accepted

I don't know how to disable it but you can easily work around it.

Just press = ( ) F2 Left Arrow

The reason it's evaluating the formula and displaying an error is that it thinks the arrow key is to navigate to another cell to include its reference in the formula. What you're wanting to do is navigate within the formula. That's what F2 does. It toggles between cell-to-cell navigation and in-formula navigation.

share|improve this answer
ahh cool, thank you very much, if only there was a way to make that the default toggle :) – ioSamurai Sep 14 '10 at 17:11

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .