<ENTER> in Excel

mkstainton · Oct 21, 2008

When I hit the <ENTER> key in Excel, I now move to the right instead of moving down a space. This just started over the weekend and is very annoying. Is there a setting that got changed somehow?

LauraR · Oct 21, 2008

From Excel 2003 help:

When you press ENTER to finish working in a cell, Microsoft Excel moves the cursor one cell down by default. However, you can select the direction in which you want the cursor to move.

On the Tools menu, click Options.

On the Edit tab, do one of the following:

To change the direction in which the cursor moves, select the Move selection after Enter check box, and then select a direction in the Direction box.

To keep the cursor in the current cell, clear the Move selection after Enter check box.

Note When a range or set of ranges is selected, pressing ENTER moves the cursor within the range or set or ranges only.
Click to expand...

mkstainton · Oct 21, 2008

Thank you very much. I have no idea how that got changed.

Thanks

LauraR · Oct 21, 2008

No prob. Hope it works.

Log in or Sign up

<ENTER> in Excel

mkstainton Private E-2

LauraR MajorGeeks Super-Duper Administrator Staff Member

mkstainton Private E-2

LauraR MajorGeeks Super-Duper Administrator Staff Member