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.