Chapter 6 Filter data, use absolute references and paste values ・ MISSION 26

Mission 26: Narrow down stores with filters

📋 Mission list

Keycat

Let's narrow down the sales table to only the rows with store code "T01". The filter is already attached.

A1fxStore

Store

Date

Sales

T01

9/1

12000

O01

9/1

8600

T02

9/1

7400

T01

9/2

13100

N01

9/2

5200

T01

9/3

11800

O01

9/3

9100

T02

9/3

6900

Keystrokes 0/ Best example: 6

Chapter 6 ・ MISSION 26

Narrow down stores with filters

Let's narrow down the sales table to only the rows with store code "T01". The filter is already attached.

Now

Store

Date

Sales

T01

9/1

12000

O01

9/1

8600

T02

9/1

7400

T01

9/2

13100

N01

9/2

5200

T01

9/3

11800

O01

9/3

9100

T02

9/3

6900

Goal

Store

Date

Sales

T01

9/1

12000

T01

9/2

13100

T01

9/3

11800

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

Shortcuts used in this mission

Alt↓
→E
→T
→0
→1
→Enter

Alt+↓ opens the filter menu. Press E, type your search and press Enter. There is no need to click the ▼ button.

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.