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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,572 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,615 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,624 questions
0 comments No comments
{count} votes