If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
A question about Excel 2003 Dialog Boxes
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. -- GoBow777 |
#2
|
|||
|
|||
A question about Excel 2003 Dialog Boxes
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. |
#3
|
|||
|
|||
A question about Excel 2003 Dialog Boxes
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? -- GoBow777 |
#4
|
|||
|
|||
A question about Excel 2003 Dialog Boxes
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? |
#5
|
|||
|
|||
A question about Excel 2003 Dialog Boxes
Gord Dibben;867804 Wrote: 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. -- GoBow777 |
Thread Tools | |
Display Modes | |
|
|