Jump to the end of your data
Step 1 of 5
Real sheets have thousands of rows. Instead of pressing an arrow key again and again, hold Ctrl (Cmd on a Mac) and press the arrow: you jump to the last filled cell in that direction.
Click Continue when you're ready.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Amount | ||||
| 2 | INV-101 | 120 | ||||
| 3 | INV-102 | 85 | ||||
| 4 | INV-103 | 240 | ||||
| 5 | INV-104 | 60 | ||||
| 6 | INV-105 | 310 | ||||
| 7 | INV-106 | 95 | ||||
| 8 | INV-107 | 150 | ||||
| 9 | INV-108 | 45 | ||||
| 10 | INV-109 | 200 | ||||
| 11 | INV-110 | 130 | ||||
| 12 |
Need help?
Why this works
Ctrl+arrow stops at the edge of a block of data, so it takes you to the end of a column in one key press however long the list is. Ctrl+Home and Ctrl+End take you to the first and last corners of the sheet.
Common mistake: Holding the arrow key down to scroll. On a long list it takes ages, and Ctrl+arrow gets there in one press.
The answer
- Jump to the last filled cell in a columnCtrl+Down
- Go to cell A1Ctrl+Home
- Go to the last used cellCtrl+End
Click a cell in the column and press Ctrl+Down (Cmd+Down on a Mac). Excel jumps to the last filled cell.
- Jump to the last filled cell in a columnCtrl+Down
- Go to cell A1Ctrl+Home
- Go to the last used cellCtrl+End
+5 points