Chapter 2 Cell navigation and range selection ・ MISSION 6
Mission 6: Jump to the last row
Keycat
The sales table has 30 rows. Jump straight to the last invoice in A30.
A1fxInvoice
A
B
C
D
E
1
Invoice
Owner
Amount
2
S-001
Sato
1200
3
S-002
Suzuki
4900
4
S-003
Takahashi
8600
5
S-004
Tanaka
3300
6
S-005
Sato
7000
7
S-006
Suzuki
1700
8
S-007
Takahashi
5400
9
S-008
Tanaka
9100
10
S-009
Sato
3800
11
S-010
Suzuki
7500
12
S-011
Takahashi
2200
Keystrokes 0/ Best example: 1
Chapter 2 ・ MISSION 6
Jump to the last row
The sales table has 30 rows. Jump straight to the last invoice in A30.
A
B
C
D
1
Invoice
Owner
Amount
2
S-001
Sato
1200
3
S-002
Suzuki
4900
4
S-003
Takahashi
8600
5
S-004
Tanaka
3300
6
S-005
Sato
7000
7
S-006
Suzuki
1700
8
S-007
Takahashi
5400
9
S-008
Tanaka
9100
A
B
C
D
22
S-021
Sato
3200
23
S-022
Suzuki
6900
24
S-023
Takahashi
1600
25
S-024
Tanaka
5300
26
S-025
Sato
9000
27
S-026
Suzuki
3700
28
S-027
Takahashi
7400
29
S-028
Tanaka
2100
30
S-029
Sato
5800
The tutorial is On. You can change this setting on the mission list page. Mission list
Shortcuts used in this mission
- Ctrl↓
Ctrl+↓ jumps to the bottom of a continuous block of data, even across thousands of rows.
On Mac, use ⌘ (command) instead of Ctrl (control for date, currency display, etc.).
Practise individual shortcuts or check the shortcut reference here. Shortcut drillsExcel shortcut list
Use the keys shown in this simulator. In Excel itself, ribbon letters and some shortcuts differ by language and keyboard layout.