Excel like a finance pro.
Switch between worksheets
CtrlPage DownEditing & referencesMove to the next or previous tab without touching the mouse.
Difficulty
1What it does
Ctrl + Page Down moves to the next worksheet tab and Ctrl + Page Up to the previous one — so you can flip through a workbook's tabs from the keyboard. In a model with a dozen sheets it's far faster than hunting for the right tab, and it keeps your hands on the keyboard while you build.
2The shortcut
- 1Press
Ctrl + Page Downto move one tab to the right. - 2Press
Ctrl + Page Upto move one tab to the left. - 3Hold and tap to skip across several sheets quickly.
3Before → after
Press the shortcut to play it on a sample sheet.
Before — on the first tab
Ctrl + Page Down moves one tab right, Ctrl + Page Up one tab left — no reaching for the mouse.
4When you use it
- Flip between an Inputs tab and a Summary tab as you work.
- Move through a many-tab workbook without the mouse.
- Cycle sheets while keeping your hands on the keyboard.
Want these moves already done for you? Wauvel's free tools download as branded, formula-driven Excel models — Tables, named ranges, and all.
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.