Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to move the cursor to column A after entering data column F
Is there a way when entering data in a spreadsheet - to have the cursor move
to column A after entering data in Column F or beyond? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to move the cursor to column A after entering data column F
If you enter data across the worksheet press tab, when you have entered the
data in column F press the Enter key. Check also Tools | Options |Edit that you have selected Down in the Move selection after Enter. Does this work for you? -- Rae Drysdale "tskaiser" wrote: Is there a way when entering data in a spreadsheet - to have the cursor move to column A after entering data in Column F or beyond? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how to move the cursor to column A after entering data column
try this (put in sheet module)
Private Sub Worksheet_Change(ByVal Target As Range) If ActiveCell.Column = 6 Then ActiveCell.Offset(, -ActiveCell.Column + 1).Select ' If ActiveCell.Column = 6 Then ActiveCell.Offset(-1, -ActiveCell.Column + 1).Select ' if u want same row End Sub "tskaiser" wrote: Is there a way when entering data in a spreadsheet - to have the cursor move to column A after entering data in Column F or beyond? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
How do you Stop Entering Duplicate Data in a Column? | Excel Worksheet Functions | |||
How can I cut data from one column and move it to another. | New Users to Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |