A question about Excel 2003 Dialog Boxes

[GoBow777]

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

Can anyone answer why this is?

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

 

[Gord Dibben]

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

 

[GoBow777]

When in these dialog boxes you are in Enter or Point mode(as can be see
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

Thank you Gordon but I know about the F2 key.

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

 

[Gord Dibben]

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


Gord

 

[GoBow777]

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


Gord

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

Good enough for me.

Thanks Gord