When you type info into Excel and press the Enter crucial, the choice box transfers to the cell below. This is the standard habits of Excel, however you might discover this aggravating. Fortunately, the default setting can be altered.

A fast and basic service to stopping the selected cell from being altered is to push the “Ctrl” and “Enter” secrets together, instead of just pressing “Enter.” Utilizing the crucial combination makes sure that the cell you typed the info into remains the active cell.

This is a nice quick service for one-off instances, however you can likewise edit the Excel options to completely stop Excel from moving the selection box.

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

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

From there, click the “Advanced” button and after that uncheck the “After Pressing Enter, Move Selection” box to disable all motion of the chosen cell.

You might change the instructions of the chosen cell by utilizing the “Direction” list.

These changes will impact all workbooks guaranteeing that Excel behaves how you need it to.