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

Mission 13: Fill a formula right

📋 Mission list

Keycat

Let's copy the profit formula (sales - expenses) in B4 to the May and June columns (C4 to D4).

Keystrokes 0/ Best example: 3

Chapter 3 ・ MISSION 13

Fill a formula right

Let's copy the profit formula (sales - expenses) in B4 to the May and June columns (C4 to D4).

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. →CtrlR

Ctrl+R fills right from the leftmost cell, just as Ctrl+D fills down.

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