Chapter 3 Edit cells, fill ranges and copy formulas ・ MISSION 12

Mission 12: Fill a formula down

📋 Mission list

Keycat

Let's copy the tax-included calculation formula in B2 to B3-B5.

Keystrokes 0/ Best example: 4

Chapter 3 ・ MISSION 12

Fill a formula down

Let's copy the tax-included calculation formula in B2 to B3-B5.

Now
Goal

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

Shortcuts used in this mission

  1. Shift↓
  2. →Shift↓
  3. →Shift↓
  4. →CtrlD

Ctrl+D "Copy the cell above down". Formula references (A2 → A3...) are also automatically shifted.

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).