Chapter 4 Edit rows and columns; calculate totals ・ MISSION 19

Mission 19: Add a filter

📋 Mission list

Keycat

Add a filter (▼ button) to the expense table heading.

A1fxDate

Date

Item

Amount

9/1

Transportation expenses

640

9/2

Stationery

1200

9/4

Transportation expenses

480

9/5

Meeting expenses

3200

Keystrokes 0/ Best example: 1

Chapter 4 ・ MISSION 19

Add a filter

Add a filter (▼ button) to the expense table heading.

Now

Date

Item

Amount

9/1

Transportation expenses

640

9/2

Stationery

1200

9/4

Transportation expenses

480

9/5

Meeting expenses

3200

Goal

Date

Item

Amount

9/1

Transportation expenses

640

9/2

Stationery

1200

9/4

Transportation expenses

480

9/5

Meeting expenses

3200

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

Shortcuts used in this mission

CtrlShiftL

Turn on/off the filter with Ctrl+Shift+L. If you are somewhere in the table, the range will be determined automatically.

On Mac, use ⌘ (command) instead of Ctrl (control for date, currency display, etc.).

Practise individual shortcuts or check the shortcut reference here. Shortcut drills Excel 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).