Chapter 2 Cell navigation and range selection ・ MISSION 10

Mission 10: Copy the amount column in bulk

📋 Mission list

Keycat

Let's copy the amounts from C2 to C12 all together from E2 down.

C2fx1200

Invoice

Owner

Amount

S-001

Sato

1200

S-002

Suzuki

4900

S-003

Takahashi

8600

S-004

Tanaka

3300

S-005

Sato

7000

S-006

Suzuki

1700

S-007

Takahashi

5400

S-008

Tanaka

9100

S-009

Sato

3800

S-010

Suzuki

7500

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.

Now

Invoice

Owner

Amount

S-001

Sato

1200

S-002

Suzuki

4900

S-003

Takahashi

8600

S-004

Tanaka

3300

S-005

Sato

7000

S-006

Suzuki

1700

S-007

Takahashi

5400

S-008

Tanaka

9100

Goal

S-003

Takahashi

8600

S-004

Tanaka

3300

S-005

Sato

7000

S-006

Suzuki

1700

S-007

Takahashi

5400

S-008

Tanaka

9100

S-009

Sato

3800

S-010

Suzuki

7500

S-011

Takahashi

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 drills Excel shortcut list

Use the keys shown in this simulator. In Excel itself, ribbon letters and some shortcuts differ by language and keyboard layout.

* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).