Keyboard shortcut tip – Filter by selection with Menu Key

Excel Tips - Filter by selection with Menu Key

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:

Excel Tips - Filter by selection with Menu Key 1

Excel Tips - Filter by selection with Menu Key 2

Here’s a step-by-step screenshot:

Excel Tips - Filter by selection with Menu Key 4

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)?


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips, Shortcut and tagged , , . Bookmark the permalink.

5 Responses to Keyboard shortcut tip – Filter by selection with Menu Key

  1. karthik says:


    In excel what is the short cut of filter by selected cell value


  2. Sabine says:

    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.


    • MF says:

      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. 🙂


  3. Pingback: Excel Roundup 20150427 « Contextures Blog

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.