Forum Discussion
Jump to specific cell after pressing enter
Hi all, Is there a way to force Excel to jump to a specific cell after pressing enter? I have 2 columns of data that I'd like to alterate between quickly, i.e. A2, then D2, then A3, then D3, ...
Hi Mike,
If you're able to move the columns to be next to one another, try making a single rectangular selection of the cells you'd like to edit in the two columns (i.e. not using the ctrl key to make multiple selections). I've found that, at least as of Office 2021, pressing tab in this context will advance the cell selection to the right (or if you override the Enter button direction to move focus to the right, pressing Enter as well).
If you're able to move the columns to be next to one another, try making a single rectangular selection of the cells you'd like to edit in the two columns (i.e. not using the ctrl key to make multiple selections). I've found that, at least as of Office 2021, pressing tab in this context will advance the cell selection to the right (or if you override the Enter button direction to move focus to the right, pressing Enter as well).