Chapter 1 Copy, cut and undo ・ MISSION 5

Mission 5: Copy multiple cells at once

📋 Mission list

Keycat

Copy all branch names from A1 to A3 to C1 to C3.

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.

Now
Goal

The tutorial is On. You can change this setting on the mission list page. Mission list

Shortcuts used in this mission

  1. CtrlShift↓
  2. →CtrlC
  3. →→
  4. →→
  5. →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.

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