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.
—Update—
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!
75 Responses to “Right-click from the keyboard, not the mouse.”
@Jeff
This key is removed is the newer versions of the Dells Latitude Laptop's
When I brought my Dell Inspirion, the one thing that I made sure was that the particular model had the key (as I am very used to it)
If you are stuck with a keyboard that does not have this key you can say SHIFT+F10 and curse the manufacturer for making your keyboard shortcut 1 key longer
Sam, I forgot about that work-around. Thanks for reminding me.
Yes, i too aware of right click on keyboard, and on this Diwali(Dhanteras), I bought dell inspiron 15 and too has not right click so using Shift+F10.
can change shift+F10
People like me who rarely uses the mouse miss the "right-click" key on the keyboard. "Shift+F10" works fine in excel but the right click key worked in any program.....
Do anybody know how to program the keyboard to contain the function of right click in all appliations??
thanks.. even i have a same laptop n was stuck
just use tap 2 fingers on touchpad to get the right click effect of the mouse!!!
I used this key a lot on my previous keyboards, but my current Logitech Wave (it's a few years old) lacks this key (Logitech has replaced it with their own function key "Fn" and moved the menu key to the most inconvenient location: "Fn+PrtScn"), so I never use it any more.
Hi, this is one of my favourite keys (I'm a keyboardoholic) and if its missing from your keyboard you can get the same result with pressing Shift+F10!
Thanks, Marton...have added this to the main blog entry.
Thanks, searching it from long time
I Didn't ever use this key before and during search i got your blog which solves the problems of my Rt. click not working Mouse. Thanks a Lot.
Good timing, Putques...I only posted this yesterday!
If you use Excel a lot, be sure to bookmark this blog. It's filled to the brim with Excellence!
Vitalie,
Well then: logitech setpoint and autohotkey should be your best friend.
Yep, I have one of these Dell Latitudes, so I used a .exe created from AHK to remap the right CTRL key to the MENU key. (I got really used to having it from my old ThinkPad.) It's not ideal, because I used to use R-CTRL for some shortcuts (printing), and now some CTRL shortcuts are two-handed, but I still like having the MENU key more.
Hey I would love to know how you did that--- I would love to reprogram my rt contol key for a rt click. thanks!
I use the menu key ALL THE TIME. I can't imagine any manufacturer removing this key (well, I can imagine Dell doing something dumb like this, but anyway).
I am using this kind of key board since last 15 years, but honestly, I didn't know about this key. Thnx..
I use Logitech K240 as my main keyboard. This is a wireless keyboard. And to save space, they have mixed the CTRL and Menu keys in to one. So now, I press FN + CTRL to activate this. I find it a bit annoying (given the fact that my right mouse button is just a few inches away).
I thought you were on holiday, boss! You should only be posting photos of the beach!
It was a short holiday. We got back on Monday morning 🙂
Me too own this Keyboard 🙂
I know the menu key located on the key board, however Shift+F10 is new to me. Thanks for the tip... 🙂
This button is only on my work keyboard, right by the Ctrl & Windows button; both of which I use very often (especially Ctrl).... I always find myself accidentally hitting this menu button instead. The aggravating part is when I'm doing something that I can complete with shortcuts and imp focusing on the keyboard but don’t realize that I hit this button.... I go through the rest of the process and it’s only when I look up at my screen that I realize that this little menu is up there staring at me (most likely laughing)
Wonder no more: of course I use that key! Not so much in Excel since the Ribbon gave me relatively easy keyboard access to any command. But I use it in other programs frequently.
hi. i use this key in keyboard often in excel while doing copy n paste special for selecting menu
Unless I'm mistaken, the Menu key or Shift+F10 gives you the Menu but a right click gives you the Menu plus a mini toolbar.
Esta dica eu conheço desde os 13 quando tive o primeiro contato com um PC.
Apredi por acaso também, testando o teclado.
Not at all. I always ignored this key for some reason. Thanks!
I always used to use this until I got a wireless keyboard for work. So, I haven't used it for about a year. It is one of the most helpful keys. But, now I can use it again without having to use the mouse. Thanks for the Shift+F10 hint. This is great.
No dice on the Lenovo wireless Keyboard. Does anyone else have this and has found the workaround. The Shift+F10 did not work.
Figured it out. On the Lenovo wireless keyboards it is the (Windows + shift + F10). A lot of keys, but may be worth it not having to use the mouse.
If you don't want to do the SHIFT+F10 method, you could add this macro to your personal collection.
Sub CellContextMenu()
Application.CommandBars("Cell").ShowPopup
End Sub
Then just assign it to some keyboard combination. Since the menu button is in the lower-left, maybe something like CTRL+SHIFT+Z.
This assumes that you no longer have that key on your keyboard, like me.
Good idea, Jordan. I wonder if the macro can be generalised to handle any context, and not just the cell context?
I was wondering that , too, but it's not really my forte. I think (but am very open to being wrong) there's no way to do a generalized version. You would probably had to test for each context (also a challenge) and return the correct menu.
What I'm thinking is... if you really wanted to have this functionality everywhere, rather than have code to pull back the specific menus for each context, you could instead make your own context menu with your favorite items and have that present itself via this macro and keyboard combination.
Doh!! News to me 🙂
Well that really underscores the importance of experts revisiting the basics from time to time!
Not sure I qualify as an expert in XL. Development? Maybe. XL? Not really. In any case, technology of any kind changes so fast that continuous learning is required. Adapt or die.
The AWESOME thing about the 'net is its ability to connect us to people all across this planet and learn.
Didn't have a clue what the key was for (didn't even notice it until I seen the email about it today), I'm excited to try it now :).
Shift-F10 works on every app, not just Excel. I have an old dell latitude running XP and Shift-F10 is handy when in a browser and I want to select text and then copy or search -- it gives me the context-sensitive menu just like right-click but without my hands leaving the keyboard.
hi chandoo;
yes this short cut is awesome!
thank you to mention it!
i've made a video about it and i call it : the most important KeyBord shortcut of your PC!
http://www.youtube.com/watch?v=BK5NLstyKFA
you can find it if you make this research videos about this : https://www.google.com/search?q=the+most+important+KeyBord+shortcut+of+your+PC
thank you .
Sure, I know and use that a lot.
It’s very convenient when you don’t want to take hands from keyboard to right-click.
Oh I love that key. Most of my moms family is right handed (I'm lefty) and right clicking on their desktops is not so natural. Keyboard short-cuts are my best friend especially that one. to pick all the crazy "Paste" options in Excel
I use it all the time in other programs. Here's my spell-checking workflow for emails / documents:
1. Type a sentence as fast as possible
2. Look for the red squiggly lines
3. Navigate to the bad word
Move the cursor with CTRL-left or -right arrow (jumps one word at a time)
4. MENU to bring up a list of suggestions, ENTER to choose
(sometimes you have to use the down arrow)
This whole time your eyes haven't left the content on-screen, and your fingers haven't left the keyboard.
(even works when typing in this comment box (IE10))
I learned something knew today. Thank you bud.
Thanks - now I would like to find out the key identifier so I can block users from using it on my Excel VBA application!
Application.Onkey :{MENU}" faults out - anyone know?
Ooh, good question, Mark. My suggestion: Just pry the offending key out with a screwdriver on all users' keyboards 🙂
You can use Alt+Menu Key to access the error menu that pops up next to a cell that contains an error (green triangle in top left corner). Then use the underlined letter in the menu to perform one of the menu options like Convert to Number or Ignore Errors.
Alt+Menu Key+C is the keyboard shortcut to convert text to numbers when a cell or range that contains errors is selected.
Alt+Menu Key+I ignores errors.
This also works for the paste options box if you are using Excel 2007.
I actually just wrote a blog post and video on this a few days ago.
http://www.excelcampus.com/keyboard-shortcuts/excel-keyboard-shortcuts-convert-text-to-numbers-ignore-errors/
Found an answer to the menu key kill is not quite what i expected, but it does do the job, and it's less likely to get the IT staff upset than Jeff's suggestion! 🙂
Application.CommandBars("Cell").Enabled = False
This will kill the pop up conext menu from the MENU key and the mouse right click button.
Killjoy! Many of the keyboards of my youth have both Caps Lock and Insert missing. Long after I've moved on to another department!
Lenovo has this key but very few dell laptops might be having it! Very handy and powerful key !!
Shift+F10
Yes. I knew it, and it had been reinforced by the recent post about copy and paste value.
as a side topic...
One day, I press CTRL+ALT+Down Arrow together, everything on my screen turn upside down; then I discover the existence of CTRL+ALT+Arrow Key
Yes. I knew it, and it had been reinforced by the recent post about copy and paste value.
as a side topic...
One day, I press CTRL+ALT+Down Arrow together, everything on my screen turned upside down; then I discover the existence of CTRL+ALT+Arrow Key
I use right click button to delete rows or columns by pressing
right click button + D in succession.
Cheers!
Yeah, it is one of my favourite keys. And I have been missing it a lot, since I moved to using windows on a Bootcamp Macbook.
Sam, thanks for the Shift+F10 tip. It might save me numerous number of times - my heart misses a beat everytime I got to use the trackpad for right click 🙂
So much for being an keboardoholic!!!
Knew about it, but don't like using it. Most of the time there's a more direct keyboard shortcut (e.g. Cut, Copy, Paste Special, Format Cell, Insert, Delete).
Fair point, Luke.
Fantastic tip!!! Plus, it works here in my browser too!
I'm a big fan of playing the keys for everything. I've been on Office 2010 for two years and I'm still using Office 2003 keyboard shortcuts for a lot of frequent tasks. I'm sure I'll work the menu key into my repertoire soon enough.
Thanks for the tip!
I did know about it, but only for the last year or so. After about 100 years of using all the other keys I one day wondered what this thing at the end of my fingers was that I never touched. So I touched it. Oooh, cool. I discovered the Windows key at the same time. Also handy.
btw great topic of discussion Jeff! It's interesting to see how many variations of the keyboard there are. The Lenovo T420 laptop has the Menu Key, but the T430 does not. It was replaced with a print screen key.
I never knew about using mouse right button through key board
i usually use that key
it's very useful key
i do not know before
but i do not know also more buttons and keys function at least i can name the key now if my children asked me now.
Thanks alot
Yeah. As said before Shift F10 is good.
The harder to simulate is the "click" or "double-click" behavior.
Keys Windows +D/M to access the desktop.
Keys Ctrl Escape + Esc (again) : to access the task bar
Once the task bar is reached, key "tabulation" to navigate to the systray 😉
Very useful post for those who are wondering where is right click on the keyboard....Thanks again: )
Thanks.....now,my problem is solved...
Shift + F10 = great! I have a Dell notebook does not have right click key!
[…] There’s a good discussion over at Chandoo’s blog about the menu key, and what to do if some tight-wad manufacturer hasn’t put it on their […]
[…] way (Shft+Tab, Home, Ctrl+Shft+RightArrow, Menu, O). Go ahead and try it. You know you want to. The Menu key is the key between Alt and Ctrl on the right side of my keyboard. Even if I concentrate really hard […]
Thanks for one's marvelous posting! I definitely
enjoyed reading it, you may be a great author. I will ensure that I bookmark your blog
and will eventually come back sometime soon. I want to encourage that you
continue your great posts, have a nice day!
Shift F10 does NOT work on my win7 64bit.
Thanks, it worked.
Yes, I did know about that key. It's a great tool to have when you want to quickly access different menu options without having to use the mouse. It's especially useful when you need to quickly select and edit a large amount of data. With just a few clicks, you can easily select the data you want to edit and then use the menu key to access the different menu options to make the desired changes. It's a great time saver and definitely worth knowing about.