This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Sorry if this has been discussd before (I tried but couldn't find anything) ....
I am trying to edit a rule for conditional formatting BUT whenever I use the Cursor arrows on the keyboard (<- ->) instead of moving the cursor in the formula, Excel moves the selection in the worksheet and adds the new cell reference to the formula so ...
I have:
and my cursor is at the end of the line. When I try to move left to go tro the start of the formula, I get ...
In fact it doesn't matter where the cursor is in the equation - if I try to move Right or Left I get a cell reference +$#$#
I have tried Ctrl-Left, Shift-Left,Alt-Left, Alt Gr-Left, to no avail.
I guess I have selected some option somewhere but I'll be dammned if I can find it.
Can anybody help me ??
Mark
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
hi Mark. it is the same scenario when you are trying to do a formula in excel. the moment you press:
=
you can move the arrow keys to select which cells you want. to disable it temporarily, press F2. like in formulas, pressing F2 in the above window would disable that
FWIW, this behavior is the same in the Name Manager's Refers to: and hte Data Validation's Source text box; i.e. the same behavior as editing a formula in the formula bar or within a cell. I'm sure there are others that I have not mentioned. Sometimes I find myself absently tapping F2 before editing a format mask within Format Cells, Number, Custom, Type: where it doesn't actually apply.
glad to help. i'm not 100% certain but no, not that i know of.
hi Mark. it is the same scenario when you are trying to do a formula in excel. the moment you press:
=
you can move the arrow keys to select which cells you want. to disable it temporarily, press F2. like in formulas, pressing F2 in the above window would disable that
Great - thanks. Do you know if there is an option to change the default mode so that I have to prss F2 to change to Select Cell mode?