4

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?

1 Answer 1

4

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.

1
  • ahh cool, thank you very much, if only there was a way to make that the default toggle :)
    – MetaGuru
    Sep 14, 2010 at 17:11

You must log in to answer this question.

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