Excel like a finance pro.
The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.
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.
Get my free report →