Chapter 2 Cell navigation and range selection ・ MISSION 8
Mission 8: Jump to the last used cell
Keycat
Let's move to the bottom right cell (C30) in the range that contains data.
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 8
Jump to the last used cell
Let's move to the bottom right cell (C30) in the range that contains data.
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
- CtrlEnd
Ctrl+End to go to the last cell of data (bottom right). Also useful when checking the size of a table.
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.