The Arrow keys, Enter, Tab guide
Tab finishes an entry and moves right; Enter moves down. Type across a row with Tab and finish with Enter, and Excel goes back to the column where you started, on the next row. Shift+Tab and Shift+Enter go the other way.
Typing a row of data
Type the first value and press Tab: the cursor moves to the next cell on the right. Keep going to the end of the row, then press Enter. Excel remembers where your Tabs started, so Enter lands back in that column on the next row, ready for the next record. Microsoft documents this as the default behaviour.
Press Enter on its own and the selection just moves down, which is right for typing a column of numbers and wrong for a row of fields.
The other keys
- Arrow keys move one cell. While you're typing a new value, an arrow key also finishes the entry and moves, like Tab.
- Shift+Tab and Shift+Enter move left and up, so you can fix the cell you just left.
- Esc throws away what you're typing and keeps the old value.
- F2 opens the cell for editing instead of replacing it; arrows then move inside the text.
Common mistakes
- Enter between fields. The rep's name ends up under the order number. Use Tab to go right.
- A Tab too many at the end of the row. Enter still returns to the first column, but the record now has an empty field on the right.
- Clicking to fix a cell, then carrying on. A click starts a new run, so the next Enter goes down from where you clicked.
You can change which way Enter moves in File → Options → Advanced (Excel → Preferences → Edit on a Mac). Tab always moves right.
FAQ
- How do I move to the next cell in Excel without the mouse?
- Tab moves right, Enter moves down, Shift+Tab moves left and Shift+Enter moves up. The arrow keys move one cell in any direction.
- Why does Enter go back to the first column in Excel?
- If you typed across a row with Tab, Enter goes to the start of the next row, the column where your Tabs began. That's Excel's default, made for typing records one row at a time.
- How do I change the direction Enter moves in Excel?
- File → Options → Advanced → "After pressing Enter, move selection", and pick a direction. On a Mac it's in Excel → Preferences → Edit.



































































