Right-click from the keyboard, not the mouse.
Well here’s something I never knew until today…I was watching one of Mike ExcelIsFun Girvin’s great YouTube videos from his great Slaying Excel Dragons series – the one on Excel 2010 Keyboard Shortcuts – when he showed how to do the equivalent of a mouse right click using a key on the keyboard that I’d never noticed before…the Menu key.
The menu key is located to the right of the space-bar, tucked in between the Windows key and the right Ctrl key.
I wonder if even Dick Kusleika knows that one. (Legend has it that the only time that Dick’s fingers leave the keyboard is when he “salutes” Excel when it crashes.)
Hui pointed me to a recent post right here called Replace formulas with values using this shortcut that covers this very tip, but somehow I missed it.
Did you know about that key? Be honest now, in the comments below.
Both Sam and Marton have reminded me that if you don’t have the menu key, you can instead use Shift+F10 to do the same thing. Thanks, chaps…without you, I’m half-baked!
Sign-up for our FREE Excel tips newsletter:
Here is a smart way to become awesome in Excel. Just signup for my FREE Excel tips newsletter. Every week you will receive an Excel tip, tutorial, template or example delivered to your inbox. What more, as a joining bonus, I am giving away a 25 page eBook containing 95 Excel tips & tricks. Please sign-up below:
Your email address is safe with us. Our policies
Leave a Reply
|Big trouble in little spreadsheet||Did Jeff just chart?|