Automatically move the cell pointer after entering data in Excel 2007

After entering data in a cell or in a blank active cell, once you press the Enter key then by default, the cell that is below the data entered or blank active cell now becomes the active cell (Active cell has a black border). You can also change this setting and make the active cell to move to the right or left or top. Perform the following steps to move the cell pointer to one of the directions that you prefer:
1. Open Microsoft Excel.
2. Click the Microsoft Office Button and click Excel Options.

Keyboard shortcut for Excel Options: Press Alt + F + I (Alt F I).

3. From the Excel Options dialog box, click Advanced from the left pane.
4. From the right pane, under Editing options, click the Direction: dropdown down that is just below the After pressing Enter, move selection checkbox.
5. Choose one of the following: Down, Right, Up, Left.
6. Click OK.

As mentioned in the very first sentence that after entering the data and pressing the Enter key, Excel activates the cell that is just below the data entered cell. If Excel does not move the cell direction to right or left or top or bottom then the After pressing Enter, move selection checkbox mentioned in step 4 is not checked. Click the After pressing Enter, move selection checkbox to place a tick mark besides it and click OK.