Chapter 2 Cell navigation and range selection ・ MISSION 10
Mission 10: Copy the amount column in bulk
Keycat
Let's copy the amounts from C2 to C12 all together from E2 down.
C2fx1200
A
B
C
D
E
F
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: 5
Chapter 2 ・ MISSION 10
Copy the amount column in bulk
Let's copy the amounts from C2 to C12 all together from E2 down.
A
B
C
D
E
F
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
E
F
4
S-003
Takahashi
8600
8600
5
S-004
Tanaka
3300
3300
6
S-005
Sato
7000
7000
7
S-006
Suzuki
1700
1700
8
S-007
Takahashi
5400
5400
9
S-008
Tanaka
9100
9100
10
S-009
Sato
3800
3800
11
S-010
Suzuki
7500
7500
12
S-011
Takahashi
2200
2200
The tutorial is On. You can change this setting on the mission list page. Mission list
Shortcuts used in this mission
- CtrlShift↓
- →CtrlC
- →→
- →→
- →CtrlV
Select all the way to the bottom with Ctrl+Shift+↓ → Ctrl+C → Go to the beginning of the paste destination → Ctrl+V.
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.