A question about Excel 2003 Dialog Boxes


G

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
 
Ad

Advertisements

G

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
 
G

GoBow777

Gord said:
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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top