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