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

Mission 14: Enter the same value in multiple cells

📋 Mission list

Keycat

The number of returned items (B2 to B5) is 0 for all stores.Let's enter 0 in all four cells at once.

Keystrokes 0/ Best example: 5

Chapter 3 ・ MISSION 14

Enter the same value in multiple cells

The number of returned items (B2 to B5) is 0 for all stores.Let's enter 0 in all four cells at once.

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. →0
  5. →CtrlEnter

If you select a range, enter it, and confirm with Ctrl+Enter, all selected cells will have the same value.

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.