Navigating Between Sheets
Ctrl + Page Down moves to the next sheet, Ctrl + Page Up to the previous one. No mouse needed.
Flip Pages From the Keyboard
Clicking tabs is fine for three sheets. With twenty, keyboard navigation and the sheet list are far quicker.
- Ctrl + Page Down — Next sheet
- Ctrl + Page Up — Previous sheet
- Right-click arrows — Jump to any sheet
How to do it
Ctrl + Page Down = next sheet · Ctrl + Page Up = previous sheet
On a laptop you may need Ctrl + Fn + Page Down, depending on your keyboard.
| Item | What it does |
|---|---|
| Ctrl + Page Down | Moves right one sheet |
| Ctrl + Page Up | Moves left one sheet |
| Right-click arrows | Full sheet list |
| Hyperlinks | Build a menu sheet |
Ways to Move Between Sheets
Ctrl + Page Down ▸ the next sheet to the right
| Method | Best for | Speed |
|---|---|---|
| Clicking tabs | A few sheets | Fine |
| Ctrl + Page Up/Down | Sheets side by side | Fast |
| Right-click arrows | Many sheets | Fast |
| A hyperlink menu sheet | Big workbooks | Fastest |
| Name Box with a range | Jumping to a spot | Exact |
Result: Ctrl+PgDn
Over ten sheets, build a Home sheet with hyperlinks and never hunt for a tab again.
Do this
- Learn Ctrl + Page Up and Page Down
- Build a hyperlink menu in big workbooks
- Right-click the arrows for a full list
Avoid
- Clicking through twenty tabs to find one
- Not knowing the keyboard shortcuts
- Leaving a big workbook with no navigation
📌 For a workbook with many sheets, build one Home sheet of hyperlinks and navigate from there.
Practice
- Move through sheets with Ctrl + Page Down.
- Right-click the arrows for the list.
- Build a Home sheet with three hyperlinks.
Quick quiz: Your workbook has 25 sheets and people cannot find anything. What is the best fix?
- Colour every tab differently
- Add a Home sheet with hyperlinks to each section
- Delete some sheets
Show answer
Insert ▸ Link ▸ Place in This Document ▸ pick the sheet — A hyperlink menu turns a confusing workbook into a navigable one.
🔒 Want the full interactive course? This is a free preview. The complete 39-module Excel Master Course — with hands-on lessons, quizzes and a certificate — is available inside the app.
Learn Excel the fun way
Bite-size interactive lessons, quizzes, streaks and a certificate.
Start free →
Bite-size interactive lessons, quizzes, streaks and a certificate.
Start free →