Jumping cells diagonally

I am trying to find a way to move between two columns with the "enter" key
while entering numbers. I want to go from A1 to B1 to A2 to B2 to C1, etc.
but not using the Tab key. Is this possible?

Hi Jumpy

What is wrong with the tab key ?

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Jumpy" <Jumpy@discussions.microsoft.com> wrote in message news:2D28CA9B-9A20-4048-9CE3-563BB8735383@microsoft.com...
>I am trying to find a way to move between two columns with the "enter" key
> while entering numbers. I want to go from A1 to B1 to A2 to B2 to C1, etc.
> but not using the Tab key. Is this possible?

Hi
Make sure the (Move selection after Enter, Direction) is set to (Right) in the Options menu and try this..
as an example..
Hold down the CTRL key and select A1:B2 then while still holdin the CTRL key select C1:D2 then select cell A1, now release the CTRL key and enter your numbers.

HTH
JG

Uncheck "move selection after enter"
(tools|options|Edit tab)

Then Select A1:Cxxx

Hit enter to go from left to right and down one row when the row is done.



Jumpy wrote:
>
> I am trying to find a way to move between two columns with the "enter" key
> while entering numbers. I want to go from A1 to B1 to A2 to B2 to C1, etc.
> but not using the Tab key. Is this possible?

--

Dave Peterson

Look around for an old Gateway keyboard. I had one with 8 arrow keys. The
extras moved diagonally; NW, NE, SW, SE in nautical terms.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jumpy" <Jumpy@discussions.microsoft.com> wrote in message
news:2D28CA9B-9A20-4048-9CE3-563BB8735383@microsoft.com...
>I am trying to find a way to move between two columns with the "enter" key
> while entering numbers. I want to go from A1 to B1 to A2 to B2 to C1,
> etc.
> but not using the Tab key. Is this possible?

Another option is to use a Workbook_SheetChange event VBA item. Right Click
on the Excel icon to the left of "File" on the main menu and click on "View
Code"

This opens the VBA Editor to the ThisWorkbook module. Select "SheetChange"
from the right hand drop down menu above the pane on the right side. Enter
this code in the main pane:

------------------

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Application.EnableEvents = True
ActiveCell.Offset(-1, 1).Select
If ActiveCell.Column = 3 Then
ActiveCell.Offset(1, -2).Select
End If
If ActiveCell.Column > 3 Then
ActiveCell.Offset(1, -1).Select
End If
End Sub

------------------

Enter data in col A, the cell pointer moves RIGHT one cell.
Enter data in col B, the cell pointer moves DOWN one row and LEFT one cell.
Enter data in col C and beyond, cell pointer moves DOWN one cell.

HTH

Bruce


"Jumpy" wrote:

> I am trying to find a way to move between two columns with the "enter" key
> while entering numbers. I want to go from A1 to B1 to A2 to B2 to C1, etc.
> but not using the Tab key. Is this possible?