Jumping with Ctrl + Arrow
Ctrl plus an arrow key jumps to the edge of your data instantly, however many rows away it is.
Travel Without Scrolling
Ctrl and an arrow key launches the cursor in that direction until it hits the last filled cell. Ten thousand rows in one keystroke.
- Hold Ctrl — Then press an arrow
- Jump to the edge — The last filled cell
- Press again — Jumps to the next block
How to do it
Ctrl + Down · Ctrl + Up · Ctrl + Left · Ctrl + Right
Add Shift to select as you jump: Ctrl + Shift + Down selects everything to the bottom of the data.
| Item | What it does |
|---|---|
| Ctrl + Down | To the last filled row |
| Ctrl + Right | To the last filled column |
| Ctrl + Home | Back to cell A1 |
| Ctrl + End | To the last used cell |
Jumping Around
Ctrl + Down ▸ last filled row Ctrl + Shift + Down ▸ select to it
| Keys | Goes to | Adds Shift? |
|---|---|---|
| Ctrl + Down | Last filled row | Selects to it |
| Ctrl + Up | First filled row | Selects to it |
| Ctrl + Right | Last filled column | Selects to it |
| Ctrl + Home | Cell A1 | Selects to it |
| Ctrl + End | Last used cell | Selects to it |
Result: Ctrl + Shift
Ctrl moves you. Ctrl + Shift moves you and selects everything on the way.
Do this
- Use Ctrl + Down instead of scrolling
- Add Shift to select a whole column of data
- Use Ctrl + Home to get back to the top
Avoid
- Scrolling through thousands of rows by hand
- Being surprised when a blank cell stops the jump
- Confusing Ctrl + End with the real last row
📌 Add Shift and it selects instead of just moving. Ctrl + Shift + Down is the fastest way to grab a column.
Practice
- Use Ctrl + Down to reach the end of a column.
- Use Ctrl + Shift + Down to select it.
- Press Ctrl + Home to return to A1.
Quick quiz: Ctrl + Down stops after 20 rows but your data goes on for 500. Why?
- Excel only jumps 20 rows at a time
- There is a blank cell at row 21
- The rest of the data is hidden
Show answer
Press Ctrl + Down again to jump to the next block of data. — Ctrl + Arrow stops at the first empty cell. Press again to continue.
🔒 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 →