Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
keyboard shortcut | New Users to Excel | |||
Keyboard shortcut for name box | Excel Discussion (Misc queries) | |||
keyboard shortcut for sum | Excel Discussion (Misc queries) | |||
Keyboard shortcut | New Users to Excel | |||
keyboard shortcut | Excel Worksheet Functions |