Do you ever right-click on something in Excel, and the command that you wanted to use isn't on that pop-up menu? For example, if right-click on a cell, there is no command to turn off the gridlines.
If you can't find the command on the right-click menu, you have to go to the Excel Ribbon or Quick Access Toolbar (QAT) instead, and try to find the command on one of the tabs there.
What commands would you add to a right-click menu? Are there commands that you added to the QAT, that would be even better in a popup menu?
Customize the Right-Click Menus
Fortunately, Doug Glancy has created a solution to the right-click menu problem, with his MenuRighter Add-in. With Doug's free add-in, you can add commands to the pop-up menus, so the items that you need are easy to find.
The add-in is not for sissies! You need to know where the commands were on the old Excel 2003 menus – or be willing to poke around and find them.
Then, you select the right-click menu where you want to add the command, and click the buttons to add the command, and save the changes.
In the screen shot below, I have selected the ToggleGrid command from the Forms toolbar, and am adding it to the Cell popup menu, just above the Hyperlink command.
Find the Right Right Menu
There is a large collection of Targets, so it can be tricky to select the correct one. There are two Cell targets, so how can you decide which right menu is the right one?
While the MenuRighter is open, you can check the box for Show Labels on Menus. At the bottom of the list at the right, you can see the identity for the selected Cell target – 28-Cell.
If I right-click on cell A2, the popup menu also shows 28-Cell, so that confirms that I selected the Cell target that I want.
Use the Modified Right-Click Menus
After I added the Toggle Grid command to the Cell menu, I clicked Apply Changes, and closed the MenuRighter window.
Then, I can right-click on a cell, and turn the gridlines on or off.
It's a command that I use frequently, so it's very convenient to have it in the right-click menu. Thanks Doug, you made life in Excel a little easier!
Download the MenuRighter Add-in
For more instructions, and to download the MenuRighter add-in, you can visit Doug Glancy's website: MenuRighter Add-in.
Watch the MenuRighter Video
To see the steps for adding a command to a right-click menu, by using the free MenuRighter add-in, please watch this short Excel video tutorial.
Or watch on YouTube: Customize Excel Right-Click Menus