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

Mission 23: Organize and filter your roster

📋 Mission list

Keycat

Delete "Old Memo" in column C of the list and add a filter to the table.

Keystrokes 0/ Best example: 5

Chapter 5 ・ MISSION 23

Organize and filter your roster

Delete "Old Memo" in column C of the list and add a filter to the table.

Now
Goal

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

Shortcuts used in this mission

  1. →
  2. →→
  3. →CtrlSpace
  4. →Ctrl-
  5. →CtrlShiftL

Delete column → Filter flow. Ctrl+Space → Ctrl+- → Ctrl+Shift+L.

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