Controlling the Enter Key

When you press the Enter key Excel typically selects the cell beneath the current cell.

Some people change this default option so that the selected cell does not move at all when Enter is pressed.

When you think about it, you often press Enter and then immediately move back to the cell to either copy it, or format it.

If you want to change what the Enter does when you press it, you can change a setting in Excel Options.

In the Advanced section of Excel Options (press Alt t o in sequence to see Excel options) the very first option controls the Enter key.

Enter_key options

If you un-tick the option the Enter key will not change the selected cell when pressed.

You can see from the image above that you can also get the Enter to move in any of four directions.

Using the Right option may be handy if you are entering data across a page.