Excel like a finance pro.
← The libraryPractice · 2 questions →
Navigation shortcut
Move one cell to the left
Shift + Tab on Windows, Shift + Tab on Mac.
CommonDifficulty 850 · Capable
When to use it
Confirms the entry and moves one cell to the left.
The shape of it
- Windows
Shift + Tab
- Mac
Shift + Tab
Worked examples
Back one cell
Type a value, press Shift + Tab → Saved, cursor moves left
Correcting the previous cell in a row.
Dialogs
In a dialog, press Shift + Tab → Focus moves to the previous field
Works in Format Cells and every other dialog.
Protected forms
In a protected sheet, Shift + Tab → Moves to the previous unlocked cell
Form-style navigation.
Worth knowing
- Tab and Shift + Tab together cover most horizontal movement without arrows.
- Enter still returns to the starting column of the row.
- Rarely worth remembering beyond dialogs.
Where it goes wrong
- In edit mode it does not move the text cursor.
- Some laptops map Shift + Tab oddly with Fn keys.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.