如何更改Excel右键菜单

If you use the mouse most of the time, when you're working in Excel, you probably right-click, to see the popup menus. For example, right-click a column heading to insert a new column. If your favourite commands aren't on those popup menus, here's how you can change Excel right-click menus, to add them. Also, if you have a minute, please take the 3-question Excel survey on my Debra D blog. Thanks!

如果您大部分时间使用鼠标，则在Excel中工作时，可能会右键单击以查看弹出菜单。 例如，右键单击列标题以插入新列。 如果您最喜欢的命令不在这些弹出菜单上，则可以通过以下方法更改Excel右键单击菜单以添加它们。 另外，如果您有时间，请在我的Debra D博客上进行3个问题的Excel调查 。 谢谢！

缺少命令 (Missing Commands)

As handy as those right-click menus are, some of your favourite commands might not be on them. For example, I'd like to right-click to hide the grid lines, or to set the freeze panes. That would be quicker than travelling all the way up to the Excel Ribbon, and clicking the tabs and commands there.

就像那些右键单击菜单一样方便，它们上可能没有一些您喜欢的命令。 例如，我想右键单击以隐藏网格线，或设置冻结窗格。 这比一路前进到Excel功能区并单击其中的选项卡和命令要快。

更改Excel右键菜单 (Change Excel Right-Click Menus)

What commands would you add to the right-click menus, if you could? If you have a few changes in mind, you don't have to learn any programming, skills, in order to make that happen. Instead, you can download a free Excel add-in – MenuRighter – and use it to customize those right-click menus.

如果可以的话，您将添加什么命令到右键菜单？ 如果您有一些改变，则无需学习任何编程和技能即可实现这一目标。 相反，您可以下载一个免费的Excel加载项– MenuRighter-并使用它自定义那些右键单击菜单。

Doug Glancy, from the YourSumBuddy website, created the MenuRighter add-in. I've been using it for a long time, and wrote about it a few years ago. Recently, Doug released a new version, and it's much easier to use now, so if you have an old version, get the update!

来自YourSumBuddy网站的Doug Glancy创建了MenuRighter加载项。 我已经使用了很长时间了， 几年前就写了它 。 最近，道格(Doug)发布了新版本，现在更容易使用，因此，如果您有旧版本，请获取更新！

添加和删​​除命令 (Add and Remove Commands)

After you download and install the MenuRighter add-in, it adds a command at the far right of the Developer tab on the Excel Ribbon.

下载并安装MenuRighter加载项后，它将在Excel功能区上“开发人员”选项卡的最右侧添加一个命令。

Click that command to open the MenuRighter form, then choose a command, and select the toolbar where you'd like it to appear. There are lots of popup menus (Target Toolbars), but the MenuRighter helps you find the one that you need. The video below shows the steps.

单击该命令以打开MenuRighter窗体，然后选择一个命令，然后选择要显示它的工具栏。 有很多弹出菜单(“目标工具栏”)，但MenuRighter可以帮助您找到所需的菜单。 以下视频显示了步骤。

视频：使用MenuRighter更改Excel右键单击菜单 (Video: Change Excel Right-Click Menus With MenuRighter)

Watch this short video to see how to change Excel right-click menus with MenuRighter. In the video, I make a couple of simple changes to a right-click menu. You'll also see how to go back to the default menu, if you change your mind.

观看此简短视频，以了解如何使用MenuRighter更改Excel右键菜单。 在视频中，我对右键菜单做了一些简单的更改。 如果您改变主意，还将看到如何返回默认菜单。

And, if you try the MenuRighter add-in, I'm sure that Doug would love to hear your comments and feedback.

而且，如果您尝试使用MenuRighter加载项，我相信Doug希望听到您的评论和反馈。

演示地址

翻译自: https://contexturesblog.com/archives/2016/06/02/how-to-change-excel-right-click-menus/