How to Stop Excel From Moving the Selection Box When You Hit Enter

by Alan Murray

Excel Logo

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.

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.

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.

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

view original article..

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s