How to change Direction of the Enter key in Excel

If you’d like to change the choice route after urgent the Enter button in the Excel spreadsheet, then this publish will present you the way to do it. Though it strikes the choice to the backside cell, you possibly can choose every other route with the assist of this information.

Let’s assume that the C6 cell is chosen in a spreadsheet opened in Microsoft Excel. At this second, when you press the Enter button in your keyboard, it should transfer the cursor to the C7 cell. Nevertheless, there might be occasions when you may want to transfer the cursor to one other route, reminiscent of D6 or B6, or C5. In such conditions, you need to use these guides to get the job completed.

How to change the Direction of the Enter key in Excel

To change the cursor motion route or change choice route after urgent Enter key in Microsoft Excel spreadsheet, comply with these steps:

1. Open Microsoft Excel in your laptop.
2. Click on on the File > Choices.
3. Swap to the Superior tab.
4. Be certain the After urgent Enter, transfer choice choice is ticked.
5. Develop the drop-down menu and select a route.
6. Click on the OK button.

Let’s delve into these steps in element.

First, you want to open Microsoft Excel in your laptop and click on on the File in the prime menu bar. Then, click on the Choices seen in the bottom-left nook.

Subsequent, swap to the Superior tab and ensure that After urgent Enter, transfer choice choice is checked. Following that, broaden the respective drop-down menu and select a route as per your necessities.

Click on the OK button to save the change.

Change choice route after urgent Enter in Excel utilizing Group Coverage

To change choice route after urgent Enter in Excel utilizing Group Coverage, comply with these steps:

1. Press Win+R to show the Run dialog.
2. Sort gpedit.msc and hit the Enter button.
3. Navigate to Superior in Person Configuration.
4. Double-click on the Transfer choice after Enter route setting.
5. Select the Enabled choice.
6. Select the route from the drop-down checklist.
7. Click on the OK button.

To know extra about these aforementioned steps, proceed studying.

First, you want to open the Native Group Coverage Editor. For that, press Win+R, kind gpedit.msc, and hit the Enter button. Then, comply with this path:

Person Configuration > Administrative Templates > Microsoft Excel 2016 > Excel Choices > Superior

Double-click on the Transfer choice after Enter route setting on the right-hand facet and select the Enabled choice.

Then, broaden the drop-down checklist, and choose a route to which you need to transfer the choice while you press the Enter button. As soon as completed, click on the OK button to save the change.

In case you can not discover the talked about path in the GPEDIT, it implies that the Group Coverage template shouldn’t be put in. In that case, you want to obtain the administrative template for Workplace.

Change the cursor motion route after urgent Enter in Excel utilizing Registry

To change choice route after urgent Enter in Excel utilizing Registry, comply with these steps:

1. Seek for registry editor in the Taskbar search field.
2. Click on on the particular person search outcome.
3. Click on the Sure button.
4. Navigate to excel in HKCU.
5. Proper-click on excel > New > Key.
6. Identify it as choices.
7. Proper-click on choices > New > DWORD (32-bit) Worth.
8. Set the identify as moveenterdir.
9. Double-click on it to set the Worth knowledge as 1, 2, or 3.
10. Click on the OK button and restart your PC.

To be taught extra about these steps, maintain studying.

To get began, seek for registry editor in the Taskbar search field, click on on the particular person search outcome and click on the Sure button to open the Registry Editor. After that, navigate to the following path:

HKEY_CURRENT_USERSoftwarePoliciesMicrosoftoffice16.0excel

Proper-click on the excel key, choose New > Key and identify it choices.

Right here you want to create a REG_DWORD worth. For that, right-click the choices key, choose New > DWORD (32-bit) Worth, and identify it as moveenterdir.

Subsequent, you want to set the Worth knowledge. If you’d like to transfer the cursor to the proper, enter 1 as the Worth knowledge. Enter 2 if you need to transfer the cursor to the up. Equally, enter 3 if you need to transfer it to the left.

As soon as completed, click on the OK button and restart your laptop.

Learn: How to open two Excel information in separate home windows.

How do you make Enter go to the proper in Excel?

To make Enter go to the proper in Excel, you will have three choices. Nevertheless, the Excel Choices panel technique might be the best one. For that, open Excel, click on on the File > Choices, and swap to the Superior tab. Then, broaden the After urgent Enter, transfer choice drop-down checklist, and select the Proper choice.

How do you press Enter in Excel with out going to the subsequent cell?

If you’d like to press Enter in Excel however don’t need to go to the subsequent cell, you want to disable the After urgent Enter, transfer choice choice. To do this, open Excel and go to File > Choices. Then, swap to the Superior tab, and take away the tick from the After urgent Enter, transfer choice checkbox.

That’s all! Hope this information has helped you.