Change The Cursor Direction In Excel 2007

When you press Enter within an Excel spreadsheet, the cursor automatically moves to the cell below. I find this very annoying at times, particularly when I want the cursor to move to the left instead of down.

It’s easy to change the cursor direction, as described below:

1. Within Excel, click the Microsoft Office Button and click Excel Options.
2. Click Advanced.
3. Under Editing Options, click the drop down arrow beside the After pressing Enter, move selection option and select the appropriate option (down, right, up or left).
4. Click OK.

Now when you press Enter, the cursor moves in the direction that you selected in step 3.

[Photo above by Jennifer Chernoff / CC BY-ND 2.0]