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

Advertisements
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:

    Hello,

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

    Like

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

    Like

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

      Like

  3. Pingback: Excel Roundup 20150427 « Contextures Blog

Comments, suggestions, corrections are welcome.

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s