Chapter 5 Combined practice: add, organise and summarise data ・ MISSION 24

Mission 24: Delete all canceled rows at once

📋 Mission list

Keycat

The requests in rows 4 and 5 were cancelled. Delete both rows together. The total in C8 updates automatically.

Keystrokes 0/ Best example: 3

Chapter 5 ・ MISSION 24

Delete all canceled rows at once

The requests in rows 4 and 5 were cancelled. Delete both rows together. The total in C8 updates automatically.

Now
Goal

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

Shortcuts used in this mission

  1. ShiftSpace
  2. →Shift↓
  3. →Ctrl-

Shift+Space followed by Shift+↓ selects both rows. Ctrl+- deletes them and the total formula adjusts automatically.

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.