| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing conditional formatting formula, arrow keys insert range.
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Editing conditional formatting formula, arrow keys insert range.
Hit the F2 key before arrowing.
The status bar message will change from "Enter" to "Edit" Gord Dibben MS Excel MVP On Tue, 19 May 2009 14:44:01 -0700, Bob Arnett wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Editing conditional formatting formula, arrow keys insert rang
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. "Gord Dibben" wrote: Hit the F2 key before arrowing. The status bar message will change from "Enter" to "Edit" Gord Dibben MS Excel MVP On Tue, 19 May 2009 14:44:01 -0700, Bob Arnett wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Editing conditional formatting formula, arrow keys insert rang
Glad to help.
This is the same method you would use in any version of Excel. Works in all refedit boxes............like InsertNameDefineRefers to: and DataValidationCustom etc. Gord On Tue, 19 May 2009 15:57:21 -0700, Bob Arnett wrote: 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. "Gord Dibben" wrote: Hit the F2 key before arrowing. The status bar message will change from "Enter" to "Edit" Gord Dibben MS Excel MVP On Tue, 19 May 2009 14:44:01 -0700, Bob Arnett wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Editing Conditional formatting formula | Excel Discussion (Misc queries) | |||
| Using arrow keys | Excel Discussion (Misc queries) | |||
| Arrow Keys | Excel Discussion (Misc queries) | |||
| how to keyboard navigate to other cells during editing formula, when arrow keys don't work | Excel Discussion (Misc queries) | |||
| how to keyboard select cells for a formula if arrow keys don't wo | Excel Discussion (Misc queries) | |||
Linear Mode
