I am a little bit puzzled when it comes to dialog boxes, I'm trying to understand why the arrow keys (on the key board) don't work when making cell or range reference. For instance, the 'Define Name' dialog box has a control box called 'Refers to', when making entries the arrow keys are not assigned to the active curser but are assigned to the active cell on the worksheet.

Can anyone answer why this is?

P.S. I know how to navigate without the mouse.

When in these dialog boxes you are in Enter or Point mode(as can be seen on
Status Bar)

Moving the arrow will change cell reference. Very annoying.

Hit F2 to get into Edit mode and arrow keys will not do this.


Gord Dibben MS Excel MVP

On Tue, 11 Aug 2009 18:46:03 +0100, GoBow777
wrote:


I am a little bit puzzled when it comes to dialog boxes, I'm trying to
understand why the arrow keys (on the key board) don't work when making
cell or range reference. For instance, the 'Define Name' dialog box has
a control box called 'Refers to', when making entries the arrow keys
are not assigned to the active curser but are assigned to the active
cell on the worksheet.

Can anyone answer why this is?

P.S. I know how to navigate without the mouse.

Thank you Gordon but I know about the F2 key.

I was just curious, is this an area where the designers got lazy or is there a real reason for why this is?

As to why? your guess would be as good as mine.


Gord

On Wed, 12 Aug 2009 20:57:57 +0100, GoBow777
wrote:


Gord Dibben;867191 Wrote:
When in these dialog boxes you are in Enter or Point mode(as can be seen
on
Status Bar)

Moving the arrow will change cell reference. Very annoying.

Hit F2 to get into Edit mode and arrow keys will not do this.


Gord Dibben MS Excel MVP

On Tue, 11 Aug 2009 18:46:03 +0100, GoBow777
wrote:
-

I am a little bit puzzled when it comes to dialog boxes, I'm trying
to
understand why the arrow keys (on the key board) don't work when
making
cell or range reference. For instance, the 'Define Name' dialog box
has
a control box called 'Refers to', when making entries the arrow keys
are not assigned to the active curser but are assigned to the active
cell on the worksheet.

Can anyone answer why this is?

P.S. I know how to navigate without the mouse.-

Thank you Gordon but I know about the F2 key.

I was just curious, is this an area where the designers got lazy or is
there a real reason for why this is?

Good enough for me.

Thanks Gord.