How to automatically jump to another cell after hitting enter

Constance Fischer 0 Reputation points
2024-05-17T21:01:24.8+00:00

Hello All,

is there a way to automatically move from the current cell to a specified cell after pressing enter or tab?
For example:
After entering data in cell H2 and pressing enter, cell H3 is selected. If I press tab, then cell I2 is selected.
Is there a way to select a completely different cell when enter or tab is pressed - such as D8

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
Developer technologies | VB
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.