Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
When you push the enter key, you move to the cell below. How do I program
the enter key, so when I push it, I move to a different cell of my choosing. Thank you. -- Robert Rogers |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You can configure Excel to move one cell in a direction of your choosing (or
not at all). Tools Options. Click on the Edit tab, check the 'Move selection after Enter' box and use the drop-down to pick the direction. "robert" wrote: When you push the enter key, you move to the cell below. How do I program the enter key, so when I push it, I move to a different cell of my choosing. Thank you. -- Robert Rogers |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The only choices are Down, Right,Up and Left one cell at a time.
Or don't move at all. If you wanted to move from say A1 to D2 and over to F3 you must use another method. See Bob Phillips' site for methods. http://www.xldynamic.com/source/xld.xlFAQ0008.html There is another method using VBA with worksheet event code. Post back if you want to try that. Gord Dibben Excel MVP On Wed, 30 Nov 2005 16:46:03 -0800, robert wrote: When you push the enter key, you move to the cell below. How do I program the enter key, so when I push it, I move to a different cell of my choosing. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Shortcut Keys -- quick find | Excel Discussion (Misc queries) | |||
Deactivate shortcut keys in excel.. | Excel Discussion (Misc queries) | |||
Isolating a Keyboard Shortcut | Setting up and Configuration of Excel | |||
how can you customize a shortcut menu in excel? | Excel Discussion (Misc queries) | |||
Shortcut menu does not have hyperlink on it | Excel Discussion (Misc queries) |