Keyboard Shortcut

[danno-c]

Hello,

After a through review of help documentation I can not locate a keyboard
shortcut for moving the focus (cursor) to the "Name Box" portion of the
worksheet.
(Click link to see a screen shot of what I am referring to as the the "Name
Box")

BACKGROUND INFO:
Running MS Office Professional Edition 2003.

I am working with a process that requires me to quickly navigate to cels
within a very large worksheet and then perorm a series of actions, with the
cel contents, using a combination of keyboard shortcuts and macros.

To begin each series of actions I am currently typing the cel coordinates
(i.e. A567) and pressing enter to navigate to the target cel. After
completing the series of actions on the cel contents and before I can
navigate to the next cel, I must move from the keyboard to the mouse and
click on the "Name Box" to put focus there and then type my next coordinate
to initate the next series of actions.

I know this may sound trivial but this minor move from the keyboard to the
mouse is really slowing down what is otherwise a very efficient series of
keyboard short cuts and macros.

Does anyone know of a keyboard shortcut to place the cursor in the Name Box
area of the worksheet?

PS: I have been unable to get a macro to record a mouse click to put the
focus in the Name Box. If anyone knows how I can overcome this and thus
include the mouse click in a macro that would do just as well as a keyboard
shortcut.

Thank You
Dan

 

[Luke M]

The keyboard shortcut Ctrl+G brings up the Goto menu. From here, you could
type a cell address or range and then press enter to go there (just like the
name box). Also, it displays a list of any named ranges, which you can select
(using combination of Tab and Arrow keys.

So, while the Goto box is not *exactly* the name box, it appears to function
in the same way.

 

[Peo Sjoblom]

F5 brings up the same menu

--


Regards,


Peo Sjoblom

The keyboard shortcut Ctrl+G brings up the Goto menu. From here, you could
type a cell address or range and then press enter to go there (just like
the
name box). Also, it displays a list of any named ranges, which you can
select
(using combination of Tab and Arrow keys.

So, while the Goto box is not *exactly* the name box, it appears to
function
in the same way.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Hello,

After a through review of help documentation I can not locate a keyboard
shortcut for moving the focus (cursor) to the "Name Box" portion of the
worksheet.
(Click link to see a screen shot of what I am referring to as the the
"Name
Box")

BACKGROUND INFO:
Running MS Office Professional Edition 2003.

I am working with a process that requires me to quickly navigate to cels
within a very large worksheet and then perorm a series of actions, with
the
cel contents, using a combination of keyboard shortcuts and macros.

To begin each series of actions I am currently typing the cel coordinates
(i.e. A567) and pressing enter to navigate to the target cel. After
completing the series of actions on the cel contents and before I can
navigate to the next cel, I must move from the keyboard to the mouse and
click on the "Name Box" to put focus there and then type my next
coordinate
to initate the next series of actions.

I know this may sound trivial but this minor move from the keyboard to
the
mouse is really slowing down what is otherwise a very efficient series of
keyboard short cuts and macros.

Does anyone know of a keyboard shortcut to place the cursor in the Name
Box
area of the worksheet?

PS: I have been unable to get a macro to record a mouse click to put the
focus in the Name Box. If anyone knows how I can overcome this and thus
include the mouse click in a macro that would do just as well as a
keyboard
shortcut.

Thank You
Dan

 

[Luke M]

Shift+F10 also works!

(F5 may work sometimes, but within browers it may just cause a screen refresh)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

The keyboard shortcut Ctrl+G brings up the Goto menu. From here, you could
type a cell address or range and then press enter to go there (just like the
name box). Also, it displays a list of any named ranges, which you can select
(using combination of Tab and Arrow keys.

So, while the Goto box is not *exactly* the name box, it appears to function
in the same way.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Hello,

After a through review of help documentation I can not locate a keyboard
shortcut for moving the focus (cursor) to the "Name Box" portion of the
worksheet.
(Click link to see a screen shot of what I am referring to as the the "Name
Box")

BACKGROUND INFO:
Running MS Office Professional Edition 2003.

I am working with a process that requires me to quickly navigate to cels
within a very large worksheet and then perorm a series of actions, with the
cel contents, using a combination of keyboard shortcuts and macros.

To begin each series of actions I am currently typing the cel coordinates
(i.e. A567) and pressing enter to navigate to the target cel. After
completing the series of actions on the cel contents and before I can
navigate to the next cel, I must move from the keyboard to the mouse and
click on the "Name Box" to put focus there and then type my next coordinate
to initate the next series of actions.

I know this may sound trivial but this minor move from the keyboard to the
mouse is really slowing down what is otherwise a very efficient series of
keyboard short cuts and macros.

Does anyone know of a keyboard shortcut to place the cursor in the Name Box
area of the worksheet?

PS: I have been unable to get a macro to record a mouse click to put the
focus in the Name Box. If anyone knows how I can overcome this and thus
include the mouse click in a macro that would do just as well as a keyboard
shortcut.

Thank You
Dan