A year or so ago I posted about updating MenuRighter, my free add-in for customizing Excel’s right-click menus. It’s done! You can go to the MenuRighter page for a download link and instructions. Or read on for some examples of what MenuRighter can do.
MenuRigher Customization Examples
Below I’ve modified the Row menu, with the default Excel 2016 version on the left and the modified version on the right. Copy, Cut, Paste and a few other buttons were removed and Freeze Panes is added to the top:
Here’s the modified Row menu in use. Note that the button caption changes in context from “Freeze” to “Unfreeze”:
Modified Cell Menu
Here’s my modified Cell right-click menu. It’s barely recognizable, so let me restate that this is the menu you get when you right-click in a cell. I’ve again deleted the Cut, Copy, Paste, Clear Contents and several other buttons. At the top I’ve added the menu for my personal addin, cleverly named “myBar.” Just one click added the whole structure to the Cell menu:
You can see that I’ve also added a whole bunch of filtering buttons. Two of the built-in ones are pulled up a level from the Cell>Filter menu, like “Filter by Selected Cell’s Value.” There’s also a couple for my own routines, like “Filter by All Selected Values.”
“Autofilter” is there so I can toggle filtering for whatever Table or range I’m in. (If you’re looking for this one, one its locations is Worksheet Menu Bar > Data > Filter > AutoFilter).
Two Other Examples
Here I’ve added a couple of my routines to the Ply menu. That’s the one you get by right-clicking a sheet tab:
And here’s the entire File menu added to the Cell menu. Everything at your fingertips!
Just kidding. I’d never do that.
New MenuRighter Page
Again, here’s the page with the download link and instructions for the new version. Please let me know what you think if you try it.
Where the customizations are stored? In the PersonalMacroWorkbook or in the Add-in workbook?
It is possible to share your customizations with someone else?
Thanks!!
Hey Orlando. Yes, you can use an xlb file I think. Please see this comment and the couple of ones after it: https://yoursumbuddy.com/menurighter_excel_2003_and_2007/#comment-26065
Awesome work Doug! Well done definitely useful for work and home!
Good stuff and being dynamic between freeze and unfreeze
Thank you! This is great!!!