Forum Discussion
How to move down a line and to the left?
The Excel I'm using is in OneDrive, it's free version. Enter takes me to the cell 1 row below, Alt+Enter takes me to the next line within the same cell, bot how to move to the first column in the...
If you are entering data in a fixed range, you can simply use Tab. For example:
Select A8:C100. A8 will be the active cell.
Pressing Tab repeatedly will move the active cell like this:
A8 -> B8 -> C8 -> A9 -> B9 -> C9 -> A10 -> B10 etc.
Otherwise, press Enter or down arrow, then Home.
HansVogelaar No, unfortunately the 1st solution doesn't help. It works when I type, but when I use ctrl+V it always fills the 1st active cell, meaning A8 in your example, no matter where I try to paste.
My suggestion was not intended for that.