Forum Discussion
izaban
May 31, 2022Copper Contributor
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...
HansVogelaar
May 31, 2022MVP
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.
izaban
May 31, 2022Copper Contributor
Thank you so much. That works.