Chapter 4 Edit rows and columns; calculate totals ・ MISSION 19
Mission 19: Add a filter
Keycat
Add a filter (▼ button) to the expense table heading.
A1fxDate
A
B
C
D
1
Date
Item
Amount
2
9/1
Transportation expenses
640
3
9/2
Stationery
1200
4
9/4
Transportation expenses
480
5
9/5
Meeting expenses
3200
6
7
8
Keystrokes 0/ Best example: 1
Chapter 4 ・ MISSION 19
Add a filter
Add a filter (▼ button) to the expense table heading.
A
B
C
D
1
Date
Item
Amount
2
9/1
Transportation expenses
640
3
9/2
Stationery
1200
4
9/4
Transportation expenses
480
5
9/5
Meeting expenses
3200
6
A
B
C
D
1
Date
Item
Amount
2
9/1
Transportation expenses
640
3
9/2
Stationery
1200
4
9/4
Transportation expenses
480
5
9/5
Meeting expenses
3200
6
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 drillsExcel shortcut list
Use the keys shown in this simulator. In Excel itself, ribbon letters and some shortcuts differ by language and keyboard layout.