You may have no idea about the shortcut key combinations above (the middle clip art is not a key combination, ok?!). That’s normal, I guess. Most of the time we talk about keyboard shortcuts, we think about Ctrl or Alt. However, have you ever tried the Menu Key on your keyboard? (If you do not know where the Menu Key is, please read the previous post.)
If you are a fan of Autofilter AND a hater of mouse, you will love this trick.
Simply put –
- Menu Key, E, V ==> Filter by selected cell’s value (It turns on AutoFilter)
- Menu Key, E, E ==> Clear filter from the selected field
Again, picture tells more:
Here’s a step-by-step screenshot:
Give it a try! You will see the beauty of Menu Key. Just one drawback: actions performed by Menu key cannot be “undo”.
Before you read this post, what is the last time you pressed the Menu Key (intentionally)?
wmfexcel 
Hello,
In excel what is the short cut of filter by selected cell value
LikeLike
Keyboard shortcut tip – Filter by selection with Menu Key | wmfexcel
Hope this helps 😃
LikeLike
Hello MF,
your tip doesn’t work in MS 2003 Professional. The Menu Key only opens the Kontext Menu and doesn’t work with shortcuts. On one site is mentioned that you can create your own shortcuts in Excel. I’ve got that feature in Word but neither in Excel nor in Outlook.
Sabine
LikeLike
Hi Sabine,
Yes you are right. That doesn’t work for Excel 2003 because the right-click menu does not include “Filter” in Excel 2003. If I remember it correctly, it was not until Excel 2007. Therefore this menu shortcut won’t work for Excel 2003 or before.
Thanks for your input. 🙂
LikeLike
Pingback: Excel Roundup 20150427 « Contextures Blog