Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Hi Jumpy
What is wrong with the tab key ? -- Regards Ron de Bruin http://www.rondebruin.nl "Jumpy" wrote in message ... 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? |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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" wrote in message ... 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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |