If you press the Enter key in Excel, it automatically goes down one line by default. With a large number of tables, however, it would be more practical if the program moved one column to the right. This is pretty easy to set up.
Enlarge
Excel: Press the Enter key to move one cell to the right
© Microsoft
To do this, first click on “Options” in the “File” menu and then on “Advanced” in the window that opens. At the top, under the “Editing options”, you will find the setting “Move highlighting after pressing Enter”. There you can mark the selection “Right” in the drop-down menu next to “Direction”. “Above” and “Links” are also available. If you delete the tick in front of the setting, the cell marking remains when you press “Enter”. Please do not forget to confirm the change with “OK”.
Enlarge
With this setting in Excel you control in which direction a cell marker moves after pressing the Enter key. You can also deactivate automatic jumping.
© IDG
Tip:
10 tricks to work faster with Microsoft Excel
