Course
Move around with the keyboard
Stop scrolling: jump to the end of a column, the end of a row, the last used cell and back to A1 in one key press.
Exercise 1 of 5
Jump to the bottom of the data
This sheet holds 24 orders, and real sheets often hold thousands. Instead of pressing ↓ again and again, press Ctrl + ↓ to jump from A1 straight to the last order.
| Order | Region | Product | Qty | Unit price ($) | Total ($) |
| 1001 | North | Notebook | 1 | 2.50 | 2.50 |
| 1002 | South | Desk lamp | 8 | 32.00 | 256.00 |
| 1003 | East | Pen box | 6 | 6.90 | 41.40 |
| 1004 | West | Paper ream | 4 | 5.75 | 23.00 |
| 1005 | North | Stapler | 2 | 14.00 | 28.00 |
| 1006 | South | Notebook | 9 | 2.50 | 22.50 |
| 1007 | East | Desk lamp | 7 | 32.00 | 224.00 |
| 1008 | West | Pen box | 5 | 6.90 | 34.50 |
| 1009 | North | Paper ream | 3 | 5.75 | 17.25 |
| 1010 | South | Stapler | 1 | 14.00 | 14.00 |
| 1011 | East | Notebook | 8 | 2.50 | 20.00 |
| 1012 | West | Desk lamp | 6 | 32.00 | 192.00 |
| 1013 | North | Pen box | 4 | 6.90 | 27.60 |
| 1014 | South | Paper ream | 2 | 5.75 | 11.50 |
| 1015 | East | Stapler | 9 | 14.00 | 126.00 |
| 1016 | West | Notebook | 7 | 2.50 | 17.50 |
| 1017 | North | Desk lamp | 5 | 32.00 | 160.00 |
| 1018 | South | Pen box | 3 | 6.90 | 20.70 |
| 1019 | East | Paper ream | 1 | 5.75 | 5.75 |
| 1020 | West | Stapler | 8 | 14.00 | 112.00 |
| 1021 | North | Notebook | 6 | 2.50 | 15.00 |
| 1022 | South | Desk lamp | 4 | 32.00 | 128.00 |
| 1023 | East | Pen box | 2 | 6.90 | 13.80 |
| 1024 | West | Paper ream | 9 | 5.75 | 51.75 |