Excel like a finance pro.
← The libraryPractice · 2 questions →
Navigation shortcut
Move to the previous worksheet
Ctrl + Page Up on Windows, Ctrl + Page Up on Mac.
Very commonDifficulty 900 · Capable
When to use it
Moves to the previous worksheet tab to the left.
The shape of it
- Windows
Ctrl + Page Up
- Mac
Ctrl + Page Up
Worked examples
Previous sheet
Press Ctrl + Page Up → The sheet to the left becomes active
Cycles right to left.
At the first tab
From the first tab, press Ctrl + Page Up → Nothing happens
It does not wrap around to the last sheet.
Group backwards
Ctrl + Shift + Page Up → The previous sheet joins the selection
Grouping sheets for a shared edit.
Worth knowing
- Ctrl + Page Down goes forward.
- Keep summary sheets at the left so they are one keystroke away.
- Hidden sheets are skipped.
Where it goes wrong
- Accidental grouping with Shift.
- Laptops may need Fn.
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.