Change which cell is selected next

When you press ENTER to finish working in a cell, Microsoft Excel moves you to an adjacent cell or leaves you in the current cell.

1. On the Tools menu, click Options, and then click the Edit tab.
2. To move to an adjacent cell, select the Move selection after Enter check box, and then select a direction in the Direction box. To stay in the current cell, clear the check box.