Editing conditional formatting formula, arrow keys insert range.

  • Thread starter Thread starter Bob Arnett
  • Start date Start date
B

Bob Arnett

Whenever I am entering or editing a conditional formatting formula, if I try
to move to another place within the formula using the arrow keys, a range is
inserted into the formula rather than just moving my typing insertion point.
Is there any way to prevent this other than always using the mouse to
relocate within the formula?
 
Hit the F2 key before arrowing.

The status bar message will change from "Enter" to "Edit"


Gord Dibben MS Excel MVP
 
Hit the F2 key before arrowing.

The status bar message will change from "Enter" to "Edit"


Gord Dibben MS Excel MVP
 
Well, that was simple. Why didn't I ask sooner? I've been "suffering" this
since we started using Excel 2007 and never got around to posting this
question until now.
Thank you very much.
 
Well, that was simple. Why didn't I ask sooner? I've been "suffering" this
since we started using Excel 2007 and never got around to posting this
question until now.
Thank you very much.
 
Glad to help.

This is the same method you would use in any version of Excel.

Works in all refedit boxes............like Insert>Name>Define>Refers to:
and Data>Validation>Custom etc.


Gord
 
Glad to help.

This is the same method you would use in any version of Excel.

Works in all refedit boxes............like Insert>Name>Define>Refers to:
and Data>Validation>Custom etc.


Gord
 
Back
Top