Excel like a finance pro.
← The libraryPractice · 2 questions →
Navigation shortcut
Confirm the entry and move up
Shift + Enter on Windows, Shift + Return on Mac.
OccasionalDifficulty 900 · Capable
When to use it
Confirms the entry and moves up instead of down.
The shape of it
- Windows
Shift + Enter
- Mac
Shift + Return
Worked examples
Enter upward
Type a value, press Shift + Enter → Saved, cursor moves up
Entering from the bottom of a column.
Correct and return
Fix a typo below, Shift + Enter → Back to the cell above
Without reaching for the arrows.
Find backwards
In Find, Shift + Enter → Previous match
Reverse search direction.
Worth knowing
- Handy in Find and Replace to step backwards through matches.
- Same as Enter with the move direction set to Up.
- Shift + Tab is the horizontal equivalent.
Where it goes wrong
- Easy to confuse with Alt + Enter (line break).
- Rarely faster than an arrow key.
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.