| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Enter key movement direction
Is there any way to set the direction for the Enter key so that it moves to
the cell on the right instead of the cell below it? I have a serious amount of data entry that is across the sheet, not down, and the staff are so used to using the enter key when fingering instead of the tab key that it's mucking up my data. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Enter key movement direction
"Lowkey" wrote in message ... Is there any way to set the direction for the Enter key so that it moves to the cell on the right instead of the cell below it? I have a serious amount of data entry that is across the sheet, not down, and the staff are so used to using the enter key when fingering instead of the tab key that it's mucking up my data. Try this: This example causes the active cell to move to the right when the user presses ENTER. Application.MoveAfterReturn = True Application.MoveAfterReturnDirection = xlToRight Bob |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Enter key movement direction
Tools|Options|Edit tab|
Change the Move Selection after Enter to do what you want. Lowkey wrote: Is there any way to set the direction for the Enter key so that it moves to the cell on the right instead of the cell below it? I have a serious amount of data entry that is across the sheet, not down, and the staff are so used to using the enter key when fingering instead of the tab key that it's mucking up my data. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Enter key movement direction
Super!
"Dave Peterson" wrote: Tools|Options|Edit tab| Change the Move Selection after Enter to do what you want. Lowkey wrote: Is there any way to set the direction for the Enter key so that it moves to the cell on the right instead of the cell below it? I have a serious amount of data entry that is across the sheet, not down, and the staff are so used to using the enter key when fingering instead of the tab key that it's mucking up my data. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the direction of the cursor movement | Excel Discussion (Misc queries) | |||
| Set Enter Key movement in a particular sheet | Excel Discussion (Misc queries) | |||
| Change Enter key movement in one workbook only | Excel Discussion (Misc queries) | |||
| how do i set the enter key to give a horizontal movement | Excel Worksheet Functions | |||
| Enter key movement direction | Setting up and Configuration of Excel | |||
Linear Mode
