Fast Workbook Navigation & Data Jumps (Ctrl+Arrow)
Jump cleanly across large datasets using Ctrl+Arrow, Ctrl+Home, Ctrl+End, and Ctrl+PageUp/PageDown without endless scrolling.
Key takeaways while you watch
- Press Ctrl+Arrow to jump straight to the edge of the current contiguous data region.
- Press Ctrl+Home to snap instantly back to cell A1 (or the freeze-pane boundary).
- Press Ctrl+PageDown / Ctrl+PageUp to switch worksheet tabs without touching your mouse.
Drill: Predict Your Ctrl+Down Landing Cell
Starting at cell A1 in a clean contiguous table spanning A1:F150 (no blank rows), which cell do you land on after pressing Ctrl+Down Arrow once?
| Row | Order ID (A) | Region (B) | Status (C) | Amount (F) |
|---|---|---|---|---|
| 1 | ORD-1001 | North | Shipped | 1250 |
| 2 | ORD-1002 | West | Shipped | 890 |
| ... | ... | ... | ... | ... |
| 150 | ORD-1150 | East | Pending | =? |
Module 01 Knowledge Check
Answer all 3 questions and check your score to unlock credit toward completion.