How to change the direction of the Enter key in Excel

When using Excel or any program, we want to save as much time as possible so as not to reduce our performance. Besides using shortcuts, in this article, TipsMake.com will guide you how to change the direction of the Enter key to manipulate in Excel.

Normally, when you press the Enter key, you can only move down a cell and cannot move right, left or any other direction. However, there is a small customization to help you change the direction of the Enter key, follow the steps below.

First, you need to click the File item in the top left corner of the Excel worksheet. In this menu, click the Options tab on the left bar. You will see many settings, click the Advanced tab .

At the top, you will see the Editing options heading. The first option is After pressing Enter, move selection with a small dialog below. By default, the Direction will be set to Down (ie when you press the Enter key, you will move down a cell), however, you can change its direction by selecting Right , Up or Left. wish.

1. These are the most basic functions in Excel that you need to understand
2. How to calculate the number of days in Excel

How to change the direction of the Enter key in Excel Picture 1

Finally, click OK to save your changes.

Note: If you uncheck the next box After pressing Enter, move selection, you can completely disable the function of the Enter key. That means Enter will not perform any function in Excel spreadsheets anymore.

Good luck!