How to Move the Cursor in Any Direction During Data Entry in MS Excel

Question:-How to Move the Cursor in Any Direction During Data Entry in MS Excel?
Answer:-Move the Cursor in Any Direction During Data Entry in MS Excel

By default, the cell pointer in Microsoft Office Excel moves down when you press ENTER after entering data in a cell. You can, however, change the direction in which the cell pointer moves.
1. Click the Office button, click Excel Options, and then click Advanced.
2. Select the After pressing Enter, move selection check box if it isn't already selected, and then on the Direction menu, click the direction in which you want the pointer to move.

Also, when working in a document, you can make the pointer move in the opposite direction from the one you've chosen by holding down the SHIFT key while you press ENTER.