Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forcing the cursor to move to A of the next line after D of the pr
Hi, I am hoping someone can tell me how I can get the cursor to move from
column D after entering data in that cell, and when I hit enter, the cursor will automatically go to column A of the next line. My sheet is only using columns A thru D, which is the way I want it, but when I hit return or enter, I would like the cursor to go to the next line below to start data entry in column A again. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forcing the cursor to move to A of the next line after D of the pr
Hi, I am hoping someone can tell me how I can get the cursor to move from
column D after entering data in that cell, and when I hit enter, the cursor will automatically go to column A of the next line. My sheet is only using columns A thru D, which is the way I want it, but when I hit return or enter, I would like the cursor to go to the next line below to start data entry in column A again. Adding this procedure... Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 5 Then Cells(Target.Row + 1, 1).Activate End Sub to the worksheet's code window in a VBA macro appears to do what you asked. Rick |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forcing the cursor to move to A of the next line after D of the pr
Not the best, but one way...
Select (click on Column Header) Columns E - IV Format, Columns, Hide. Only A:D are now visible.. Click in A1; Press TAB Key, once, twice and a third time. Then Press the Enter-Key (While in Column D) This only work if you start Tabbing from Column A only. "Kitti" wrote: Hi, I am hoping someone can tell me how I can get the cursor to move from column D after entering data in that cell, and when I hit enter, the cursor will automatically go to column A of the next line. My sheet is only using columns A thru D, which is the way I want it, but when I hit return or enter, I would like the cursor to go to the next line below to start data entry in column A again. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forcing the cursor to move to A of the next line after D of the pr
Couple of ways to do this.
1. Unlock columns A:D then protect the sheet. The Tab key will then do as you wish or the Enter key will work if set to move right after entry. 2. With no protection, start in column A and Tab your way across to D then hit Enter key to go back to A one row down. Gord Dibben MS Excel MVP On Sat, 16 Jun 2007 07:51:00 -0700, Kitti wrote: Hi, I am hoping someone can tell me how I can get the cursor to move from column D after entering data in that cell, and when I hit enter, the cursor will automatically go to column A of the next line. My sheet is only using columns A thru D, which is the way I want it, but when I hit return or enter, I would like the cursor to go to the next line below to start data entry in column A again. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Forcing the cursor to move to A of the next line after D of the pr
Hi, I am hoping someone can tell me how I can get the cursor to move from
column D after entering data in that cell, and when I hit enter, the cursor will automatically go to column A of the next line. My sheet is only using columns A thru D, which is the way I want it, but when I hit return or enter, I would like the cursor to go to the next line below to start data entry in column A again. Adding this procedure... Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 5 Then Cells(Target.Row + 1, 1).Activate End Sub to the worksheet's code window in a VBA macro appears to do what you asked. By the way, for your request to make sense, I assumed you have your "Move Selection After Enter" option set to "Right". Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get tab to move the cursor one cell over rather than 8? | Excel Worksheet Functions | |||
Several questions about move cursor | Excel Discussion (Misc queries) | |||
Move cursor to next row | Excel Discussion (Misc queries) | |||
Move Cursor to A1 | Excel Discussion (Misc queries) | |||
Forcing text onto new line in cell | New Users to Excel |