Chapter 1 Copy, cut and undo ・ MISSION 5
Mission 5: Copy multiple cells at once
Keycat
Copy all branch names from A1 to A3 to C1 to C3.
A1fxTokyo
A
B
C
D
E
1
Tokyo
2
Osaka
3
Nagoya
4
5
6
7
8
Keystrokes 0/ Best example: 5
Chapter 1 ・ MISSION 5
Copy multiple cells at once
Copy all branch names from A1 to A3 to C1 to C3.
A
B
C
D
1
Tokyo
2
Osaka
3
Nagoya
4
A
B
C
D
1
Tokyo
Tokyo
2
Osaka
Osaka
3
Nagoya
Nagoya
4
The tutorial is On. You can change this setting on the mission list page. Mission list
Shortcuts used in this mission
- CtrlShift↓
- →CtrlC
- →→
- →→
- →CtrlV
You can select all the way to the bottom of the data at once using Ctrl+Shift+↓. After copying the range, just select one cell in the upper left to paste it to.
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.