1
Ctrl + PageDownMove to the next sheet on the right
The fundamental shortcut for advancing to the next tab — monthly reports, next process step, next project phase.
sheet navigationCtrl+PageDownmultiple sheets
Switch Between Excel Sheets at Full Speed with Ctrl+PageDown and Ctrl+PageUp
Clicking sheet tabs with the mouse gets slower as the number of tabs grows. Ctrl+PageDown and Ctrl+PageUp are the baseline shortcuts for any multi-sheet workbook.
Shortcuts you will master in this article
Ctrl + PageDown / Ctrl + PageUp / Ctrl + Shift + PageDown
Moving Between Sheets Is a Surprisingly Large Time Sink
In a workbook with monthly tabs, departmental tabs, or project tabs, you can easily spend more time navigating than entering data. Cutting just that navigation cost changes the feel of the whole file.
Sheet-switching shortcuts are unglamorous, but they activate instantly from the first day you learn them — the payoff is immediate.
Sheet Navigation: Core and Extended Techniques
Lock in right-and-left navigation first, then add the multi-sheet selection variant.
2
Ctrl + PageUpMove to the previous sheet on the left
Essential when comparing two adjacent sheets side by side.
3
Ctrl + Shift + PageDownSelect multiple adjacent sheets
Selects the current sheet and the one to its right simultaneously. Use this to apply the same formatting or data to a range of tabs at once.
4
Ctrl + HomeReturn to cell A1 on each sheet after arriving
Combining sheet navigation with an A1 reset keeps your view consistent across tabs — you always start reading from the same position.
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Tips for Making Sheet Navigation a Time Saver
For side-by-side comparison work, alternating Ctrl+PageDown and Ctrl+PageUp is far faster than mouse tab-clicking.
The more tabs that are cut off in the tab bar, the greater the keyboard advantage over the mouse.
Always deselect a multi-sheet group after your grouped edit. Forgetting to do so and then typing overwrites every selected sheet.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + PageDown | Move to Next Sheet |
Ctrl + PageUp | Move to Previous Sheet |
Ctrl + Shift + PageDown | Extend Selection to Next Sheet |
Ctrl + Shift + PageUp | Extend Selection to Previous Sheet |
Ctrl + Home | Go to A1 |
Frequently Asked Questions
Q. What if PageDown is awkward to reach on my laptop keyboard?
A. Many laptops require Fn+PageDown. Find your machine's combination once, and then the key sequence becomes automatic.
Q. How do I deselect a multi-sheet group?
A. Click any single unselected sheet tab, or right-click a selected tab and choose Ungroup Sheets. Make sure the grouping is gone before entering any data.
Q. Does this work even when the tab order is not logical?
A. Yes, though the more you rely on sheet navigation, the more you benefit from also organizing tab order to match your workflow.
Q. How do I memorize Excel shortcuts faster?
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →