Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 at 4:11

1 Answer 1

up vote 3 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
1  
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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.