Change the direction of the Enter key in Excel 2007

In Excel 2007, when you enter data into a cell and press the TAB or ENTER key then the cell that is to the right becomes the active cell. You can change this behavior by changing an Excel option and make the cell that is to the left or top or bottom to become the active cell.
Please note that this setting cannot be done for the TAB key. Pressing the TAB key will always move to the right. Perform the following steps to change the direction of the ENTER key:
1. Open Microsoft Excel.
2. Click the Microsoft Office Button and click Excel Options.
3. From the Excel Options dialog box, click Advanced from the left pane.
4. From the right pane, under Editing options, click to place a checkmark besides After pressing Enter, move selection. Click the direction in the Direction box.
5. Click OK.