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?
Asked
Active
Viewed 2,663 times
7
-
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 04:11
1 Answers
11
After you enter your formula, press F2 to enable edit mode allowing you to move the cursor with the arrow keys.
CharlieRB
- 22,754
-
3
-
-
"After you enter your formula" I am in the middle of entering my formula and I can't press F2. What do I need to do? – minseong Aug 17 '17 at 12:06
-
-
@CharlieRB yes I tried it, it just plays a "boop" noise and does nothing. I'm on a mac running excel 15.27 – minseong Aug 17 '17 at 14:37
-
I am unable to duplicate what you are seeing. You should probably ask your own question. – CharlieRB Aug 17 '17 at 15:30
-
@CharlieRB—I'm running Excel Mac 2011 and Excel behaves as theonlygusti says. I find this "feature" insanely annoying. – RobG Aug 05 '19 at 10:30