After entering data in a worksheet cell, you can use ENTER, TAB, or any arrow key to move the cursor to another adjacent cell.
Press ENTER to move the cursor
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.
Press TAB to move the cursor
When you press TAB or SHIFT+TAB, Excel moves the cursor to the adjacent cell on the right or the left.
- For the TAB key, you cannot change the direction in which you want the cursor to move.
- When a range or set of ranges is selected, pressing TAB or SHIFT+TAB moves the cursor within the range or set of ranges only.
- If you use the TAB key to move the cursor to the right and the ENTER key to move the cursor one cell down, the cursor will move below the first cell in the current row that contains text.
Use arrow keys to move the cursor
When you press an arrow key, Excel moves the cursor to the adjacent cell in the direction of the arrow.
- When SCROLL LOCK is on, the entire sheet is moved by one cell when you press the arrow keys.
- You cannot use arrow keys to move the cursor within a selected range. Pressing any arrow key cancels the selection.
Tip For more ways to navigate within a worksheet, including shortcuts that use the ARROW, HOME, END, PAGE UP, and PAGE DOWN keys, see "Keys for workbooks and worksheets" in Keyboard shortcuts.