按下Enter键时如何阻止Excel移动选择框

When you type information into Excel and press the Enter key, the selection box moves to the cell below. This is the standard behavior of Excel, but you might find this frustrating. Fortunately, the default setting can be changed.

当您在Excel中键入信息并按Enter键时，选择框将移至下面的单元格。 这是Excel的标准行为，但是您可能会感到沮丧。 幸运的是，可以更改默认设置。

A quick and simple solution to stopping the selected cell from being changed is to press the “Ctrl” and “Enter” keys together, instead of only pressing “Enter.” Using the key combination ensures that the cell you typed the information into remains the active cell.

停止更改所选单元格的一种快速简单的解决方案是同时按下“ Ctrl”和“ Enter”键，而不是仅按下“ Enter”。 使用组合键可确保您在其中键入信息的单元格保持活动单元格。

This is a nice quick solution for one-off instances, but you can also edit the Excel options to permanently stop Excel from moving the selection box.

对于一次性实例，这是一个不错的快速解决方案，但是您也可以编辑Excel选项，以永久阻止Excel移动选择框。

Start by clicking the “File” tab on the Ribbon.

首先单击功能区上的“文件”选项卡。

Next, select “Options” at the bottom of the list on the left.

接下来，选择左侧列表底部的“选项”。

From there, click the “Advanced” button and then uncheck the “After Pressing Enter, Move Selection” box to disable all movement of the selected cell.

从那里，单击“高级”按钮，然后取消选中“按Enter后，移动选择”框以禁用所选单元格的所有移动。

Alternatively, you could change the direction of the selected cell by using the “Direction” list.

或者，您可以使用“方向”列表来更改所选单元格的方向。

These changes will affect all workbooks ensuring that Excel behaves how you need it to.

这些更改将影响所有工作簿，从而确保Excel表现出所需的行为。

翻译自: https://www.howtogeek.com/462163/how-to-stop-excel-from-moving-the-selection-box-when-you-hit-enter/