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

When applying a conditional formatting rule in Excel, using the "Edit Formatting Rule" dialog, and using "Use a formula to determine which cells to format," you cannot move the caret (text insertion point) in the formula editor with the keyboard. If you try to use the arrow keys it inserts the cell name next to the cell in focus depending whether you hit the up/down/left/right key. Is there some way to turn this off? or some way to move the caret with the keyboard?

share|improve this question
It was very frustrating for me too, compounded by the facts that it is the default behavior and there is no helpful reminder in the dialog box. I almost posted a duplicate of your question. Thank you, and thanks to SE for its powerful "Similar Questions" feature. – ADTC Jul 11 '14 at 4:11
up vote 4 down vote accepted

After you enter your formula, press F2 to which will enable edit mode allowing you to move the cursor with the arrow keys.

share|improve this answer
Thanks! You have no idea how much that has frustrated me. – druciferre Jan 10 '12 at 15:17
You're welcome. Glad to help. – CharlieRB Jan 10 '12 at 15:19

You must log in to answer this question.

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