I thought that going to column 1 in Excel when one presses Enter was the default mode. On my computer, it goes to the cell beneath it.
How can I change it?
Thanks,
hh
I thought that going to column 1 in Excel when one presses Enter was the default mode. On my computer, it goes to the cell beneath it.
How can I change it?
Thanks,
hh
I don’t think you can, unless you set it as a Data Form. Then it should go to Column 1 (follow the instructions in Help on how to create a Data Form).
Alternatively, just press CTRL + Left Arrow after you’ve pressed Enter.
I think it depends on how you’re entering data. Starting in cell A1, type: 1 tab 1 tab 1 tab enter. You should have 1s in range A1:C1 and the active cell should be A2.
If you want to go to cell A1 from anywhere, Ctrl+Home will do. I don’t know a way other than adding VBA event code to make column 1 the active cell every time you press enter, but that behavior would drive me nuts anyway.
The default direction of every Excel program I’ve ever installed was to activate the cell {below} the current cell after the enter key was pressed.
The options menu gives you the choice of changing that to {Above} , {Left}, {Right}, as well as {below}.
I’ve changed it temporarily a few times to accommodate the way I wanted to enter some data. And then changed it back. Like the responses above, I don’t know of a way to force it to Column 1 other than a macro that keys on an enter event.
In my Excel 2003, presing HOME instantly takes you to column 1 in whatever row you are in, and pressing CTRL HOME instantly takes you to cell A1.
In my experience, clicking in a cell sets that temporarily as “home” or “first column” in your spreadsheet. So if you click in, say, C4 and type
1 tab 1 tab 1 tab enter
as in the example above, C4, C5, and C6 will contain “1” and your cursor will now be in D4. So any cell you click on becomes the new “first column”.
J.
Maybe the OP wants it done with VBA. Don’t do this if you are not familiar with macros.
But if you are, then write a macro for the Worksheet as follows
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveCell.Offset(-1, -Target.Column + 1).Activate
End Sub
in Tools | Macros | VBA Editor
Just checked the above and it doesn’t seem to be clicking so much as where you start from. Whether you click on C4 or use the arrow keys, typing 1 tab 1 tab 1 tab enter will end up in D4. You don’t need to enter data, either. Starting in C4 and typing tab tab tab enter will still end with D4 active.