excel 自定义菜单_自定义Excel右键菜单

excel 自定义菜单

iconmenurighter

Do you ever right-click on something in Excel, and the command that you wanted to use isn't on that pop-up menu?

您是否曾经右键单击Excel中的某个内容,而想要使用的命令不在该弹出菜单上?

For example, if right-click on a cell, there is no command to turn off the gridlines.

例如,如果在单元格上单击鼠标右键,则没有关闭网格线的命令。

menurighter01

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.

如果在右键菜单上找不到命令,则必须转到Excel功能区或快速访问工具栏(QAT),然后尝试在该选项卡之一上找到命令。

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?

您将向右键菜单添加哪些命令? 是否有添加到QAT的命令,在弹出菜单中会更好?

自定义右键菜单 (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.

幸运的是,Doug Glancy借助他的MenuRighter外接程序为右键菜单问题创建了解决方案。 使用Doug的免费加载项,您可以将命令添加到弹出菜单,因此您可以轻松找到所需的项目。

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.

该插件不适合娘娘腔! 您需要知道命令在旧的Excel 2003菜单上的位置-或愿意四处寻找它们。

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.

在下面的屏幕快照中,我从“表单”工具栏中选择了ToggleGrid命令,并将其添加到“超链接”命令正上方的“单元格”弹出菜单中。

menurighter02

查找右菜单 (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?

目标有很多,因此选择正确的目标可能很棘手。 有两个Cell目标,那么如何确定哪个右边菜单是正确的呢?

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.

打开MenuRighter时,可以选中“在菜单上显示标签”框。 在右侧列表的底部,您可以看到所选Cell目标的标识– 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.

如果在单元格A2上单击鼠标右键,弹出菜单还会显示28-Cell,以确认我选择了所需的Cell目标。

menurighter03

使用修改后的右键菜单 (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.

将“切换网格”命令添加到“单元格”菜单后,单击“应用更改”,然后关闭“ MenuRighter”窗口。

Then, I can right-click on a cell, and turn the gridlines on or off.

然后,我可以右键单击单元格,然后打开或关闭网格线。

menurighter04

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!

这是我经常使用的命令,因此将其放在右键菜单中非常方便。 谢谢Doug,您使使用Excel的生活更加轻松!

下载MenuRighter加载项 (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.

有关更多说明,以及要下载MenuRighter加载项,请访问Doug Glancy的网站: MenuRighter加载项

观看菜单右侧的视频 (Watch the MenuRighter Video)

To see the steps for adding a command to a right-click menu, by using the free MenuRighter add-in, you can watch this short Excel video tutorial.

若要查看将命令添加到右键菜单的步骤,请使用免费的MenuRighter加载项,您可以观看此简短的Excel视频教程。

演示地址

翻译自: https://contexturesblog.com/archives/2011/12/02/customize-excel-right-click-menus/

excel 自定义菜单

已标记关键词 清除标记
表情包
插入表情
评论将由博主筛选后显示,对所有人可见 | 还能输入1000个字符
相关推荐
©️2020 CSDN 皮肤主题: 编程工作室 设计师:CSDN官方博客 返回首页