What is the shortcut for Open Filter Menu?
Windows: Alt+Down. Mac: Option+Down.
📊Excel Shortcut
Open Filter Menu
Detailed guide to use "Open Filter Menu" in Excel
Shortcut Keys
The highlighted keys show where to press. Press the required keys together.
Windows
Alt+↓
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
⌫
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
↩
⇧
Z
X
C
V
B
N
M
,
.
/
⇧
Ctrl
Win
Alt
Alt
Win
Fn
Ctrl
Home
Del
End
PgUp
PgDn
↑
←
↓
→
Windows: Alt+Down
Mac
⌥+↓
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
`
1
2
3
4
5
6
7
8
9
0
-
=
⌫
Tab
Q
W
E
R
T
Y
U
I
O
P
[
]
\
Caps
A
S
D
F
G
H
J
K
L
;
'
↩
⇧
Z
X
C
V
B
N
M
,
.
/
⇧
⌃
⌘
⌥
⌥
⌘
Fn
⌃
↑
←
↓
→
Mac: Option+Down
Basic Info
- Category
- Other
- Difficulty
- ★★☆(Intermediate)
How to Use
- 1Select the target cell/range if needed
- 2Press the highlighted keys shown above together
- 3Open Filter Menu is executed
Practice
Practice this shortcut and build reliable muscle memory.
Usage Tip
Open a filter dropdown from the keyboard.
Related Shortcuts
Close Workbook
Same categoryCtrl + W
Insert Cells/Rows/Columns
Same categoryCtrl + Shift + +
Delete Cells/Rows/Columns
Same categoryCtrl + -
Hide Row
Same categoryCtrl + 9
Hide Column
Same categoryCtrl + 0
Unhide Row
Same categoryCtrl + Shift + 9
Unhide Column
Same categoryCtrl + Shift + 0
Toggle AutoFilter
Same categoryCtrl + Shift + L
More In This Category
FAQ
How do I use Open Filter Menu?
Use it on the active workbook or selection to keep routine work keyboard-first.
What shortcuts should I practice after Open Filter Menu?
Practice save, copy, and paste next and you can move through common Excel work much faster.
Where can I practice Open Filter Menu?
Use the page button to start a focused drill right away. If you switch to full practice, you can review save, copy, and paste in the same flow.