Tech

Excel: Press the Enter key to move one cell to the right






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.

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”.

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.

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

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button