May 31 2022 02:26 AM
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 next row, from let's say C8 to A9 instead of C9? Like in this video: The Beginner's Guide to Excel - Excel Basics Tutorial - YouTube (12:02). Is there a keyboard shortcut for that?
Obviously I know that I can use mouse or Enter and then Shift + Tab. I mean a simpler way. Is there one?
May 31 2022 02:38 AM
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.
May 31 2022 04:43 AM
@Hans Vogelaar 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.
May 31 2022 07:15 AM
My suggestion was not intended for that.