LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Keyboard Shortcut

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
keyboard shortcut Bumblejeep New Users to Excel 2 January 30th 09 10:15 PM
Keyboard shortcut for name box hmm Excel Discussion (Misc queries) 4 August 11th 07 01:02 PM
keyboard shortcut for sum Sarah Excel Discussion (Misc queries) 10 August 31st 06 11:20 PM
Keyboard shortcut bombayterror New Users to Excel 2 January 18th 06 05:44 PM
keyboard shortcut Aditya Excel Worksheet Functions 1 February 21st 05 01:34 PM


All times are GMT +1. The time now is 10:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"