(Advanced)Microsoft Office的(Microsoft Office)高级用户希望始终在Word或Excel程序的功能区(Ribbon)上显示“开发人员”选项卡。(Developer tab)但是,默认情况下不显示该选项卡,这意味着可以手动添加它。这样做很简单,但并不是每个人都知道如何去做。您可以使用程序的设置、组策略(Group Policy)或注册表编辑器(Registry Editor)来执行此操作。
考虑到这一点,我们决定解释如何将开发人员选项卡(Developer Tab)添加到Microsoft Office的(Microsoft Office)功能区(Ribbon)区域。
开发人员选项卡有什么用途?
- 运行 XML 命令:(Run XML commands:)Microsoft Office的一项很酷的功能是运行XML命令的能力。高级(Advanced)用户和企业主要使用这些命令。
- 开发在 Microsoft Office 工具中运行的应用程序:(Develop applications to run in Microsoft Office tools:)是的,可以根据自己的需要创建在Microsoft Office中运行的应用程序。(Microsoft Office)
- 编写和运行宏:(Write and run Macros:) 微软(Microsoft)让用户在其Office套件中编写和运行宏的时间最长。宏(Macros)很强大,因此,它们可能很危险,因为运行宏(Macro)类似于运行一行代码。你看,宏(Macros)已经被用来在Windows上安装恶意软件和其他危险病毒很长时间了,尽管微软(Microsoft)改进了安全措施,但如果以错误的方式使用宏(Macros)仍然是一个威胁。
- 使用 ActiveX 控件:(Use ActiveX controls: )Internet Explorer有自己的插件系统,称为ActiveX 控件,也可以通过Developer Tab在(Developer Tab)Microsoft Office中使用。如果您知道自己在做什么,那么请继续在您的Office文档中使用ActiveX 。但是,如果您是新手,我们建议您只安装来自受信任来源的ActiveX工具。(ActiveX)与宏(Macros)类似,我们知道ActiveX可以成为在您的计算机上安装恶意软件的来源。
如何在Office程序中添加开发人员(Developer)选项卡
好的,所以一旦将开发人员选项卡(Developer Tab)添加到Word或Excel 功能区(Excel Ribbon),它将保持可见,直到手动删除。过程很简单:
- 启动 Word 或 Excel
- 打开选项菜单
- 打开自定义功能区
- 激活开发者
让我们更详细地谈谈这个问题。
1]打开选项菜单
将开发人员选项卡(Developer Tab)添加到Microsoft Office程序的第一步是单击文件(File),然后导航到选项(Options)。您应该看到几个选择,但列表中只有一个在这方面是必不可少的。
2]打开自定义功能区
我们之前已经讲过这个部分。您会看到,如果Microsoft Office的(Microsoft Office)功能区(Ribbon)中缺少某些内容,那么您很可能会在此处找到它。如果您想从Ribbon中删除功能,也是如此。
3]激活开发人员
选择自定义功能区(Customize Ribbon)后,您应该会看到两个部分。左侧的一个称为“流行命令(Popular Commands)”,右侧的另一个称为“主选项卡(Main Tabs)” 。您将要查看开发人员的主选项(Developer)卡(Main Tabs),并确保在空框内单击。
最后,单击OK按钮,开发人员选项卡(Developer Tab)应立即出现在功能区(Ribbon)上。
如何使用组策略在(Group Policy)Word中添加(Word)开发人员(Developer)选项卡
要使用组策略在(Group Policy)Word中添加开发人员(Developer)选项卡,请执行以下步骤:
- 按 Win+R 打开运行提示。
- 键入gpedit.msc 并按 Enter 按钮。
- 导航到 用户配置(User Configuration)中 的自定义功能区 (Customize Ribbon )。
- 双击 功能区设置中的显示开发人员选项卡 。(Display Developer tab in the Ribbon )
- 选择 启用 (Enabled )选项。
- 单击 确定 (OK )按钮。
要了解有关这些步骤的更多信息,请继续阅读。
要开始,请按 Win+R 打开运行提示,键入 gpedit.msc,然后按 Enter 按钮。然后,导航到此路径:
User Configuration > Administrative Templates > Microsoft Word 2016 > Word Options > Customize Ribbon
在这里,您可以在功能区中看到一个名为“ 显示开发人员”选项卡的(Display Developer tab in the Ribbon)设置。您需要双击它并选择 启用 (Enabled )选项。
然后,单击 确定 (OK )按钮保存更改。
如何使用注册表在(Registry)Word中添加(Word)开发人员(Developer)选项卡
要使用注册表在(Registry)Word中添加开发人员(Developer)选项卡,请执行以下步骤:
- 按 Win+R 显示运行提示。
- 键入 regedit > 按 Enter 按钮 > 单击 Yes 按钮。
- 导航到 HKCU 中的(HKCU)Microsoft 。
- 右键单击 Microsoft > New > Key 并将其命名为 office。
- 右键单击 office > New > Key 并将其命名为 0。
- 右键单击 0 > New > Key 并将名称设置为 word。
- 右键单击 word > New > Key 并将其命名为 options。
- 右键单击 options > New > DWORD (32-bit) Value。
- 将其命名为 developertools。
- 双击它以将值(Value)数据设置为 1。
- 单击 确定 (OK )按钮并重新启动计算机。
让我们详细检查这些步骤。
首先,按 Win+R,键入 regedit,然后按 Enter 按钮。然后,单击 UAC提示中的Yes 选项。接下来,导航到以下路径:
HKEY_CURRENT_USER\Software\Policies\Microsoft
右键单击 Microsoft > New > Key,并将其命名为 office。
然后,按照相同的方法在office (office )密钥下创建一个子密钥, 并将其命名为 16.0。重复相同的步骤,在16.0 (16.0 )键下创建一个子 键并将其命名为 word。
右键单击 word > New > Key 并将其命名为 options。之后,右键单击 options > New > DWORD (32-bit) Value 并将名称设置为 developertools。
完成后,双击它以将值(Value)数据设置为 1。
单击 确定 (OK )按钮并重新启动计算机。
如何使用组策略在(Group Policy)Excel中添加(Excel)开发人员(Developer)选项卡
要使用组策略在(Group Policy)Excel中添加开发人员(Developer)选项卡,请执行以下步骤:
- 在任务栏搜索框中搜索gpedit.msc 。
- 单击(Click)单个搜索结果。
- 导航到 用户配置(User Configuration)中 的自定义功能区 (Customize Ribbon )。
- 双击 功能区设置中的显示开发人员选项卡 。(Display Developer tab in the Ribbon )
- 选择 启用 (Enabled )选项。
- 单击 确定 (OK )按钮。
让我们详细研究这些步骤。
首先,您需要打开本地组策略编辑器(Local Group Policy Editor)。为此, 请在任务栏搜索框中搜索(Taskbar)gpedit.msc ,然后单击单个搜索结果。
打开后,导航到以下路径:
User Configuration > Administrative Templates > Microsoft Excel 2016 > Word Options > Customize Ribbon
双击 功能区设置中的显示开发人员选项卡, (Display Developer tab in the Ribbon )然后选择 启用 (Enabled )选项。
单击“ 应用 (Apply )”和 “确定 (OK )”按钮保存更改并重新启动Excel以找到“ 开发人员 (Developer )”选项卡。
如何使用注册表在(Registry)Excel中添加(Excel)开发人员(Developer)选项卡
要使用注册表在(Registry)Excel中添加开发人员(Developer)选项卡,请执行以下步骤:
- 在任务栏搜索框中搜索 regedit 。
- 单击(Click)单个搜索结果,然后单击 是 (Yes )按钮。
- 导航到 HKCU 中的(HKCU)Microsoft 。
- 右键单击空白空间 > New > Key 并将名称设置为 office。
- 重复(Repeat)这些步骤以创建一个子键并将其命名为 0。
- 右键单击 0 > New > Key 并将名称设置为 excel。
- 右键单击 excel > New > Key 并将其命名为 options。
- 右键单击 options > New > DWORD (32-bit) Value。
- 将其命名为 developertools。
- 双击它以将数值(Value)数据设置为 1,然后单击 确定 (OK )按钮。
- 重新启动您的电脑。
要详细了解上述这些步骤,请继续阅读。
首先,您需要打开注册表编辑器(Registry Editor)。为此, 在任务栏搜索框中搜索(Taskbar)regedit ,单击单个搜索结果,然后单击 是 (Yes )选项。
然后,导航到以下路径:
HKEY_CURRENT_USER\Software\Policies\Microsoft
如果您已经为其他Office程序设置了此设置,您可能会 在Microsoft 键下找到(Microsoft )office 子 键。在这种情况下,您需要跳到第 6 步。否则,您需要为Excel手动创建所有子键。为此,请右键单击 Microsoft > New > Key 并将其命名为 office。
然后,重复这些步骤,在office(office)下创建一个子键, 并将其命名为 16.0。再次这样做以在 16.0 下创建一个子键并将其命名为 excel。最后一次,重复这些步骤以创建另一个子键并将其命名为 options。
完成后,您需要创建一个REG_DWORD值。为此,右键单击 options > New > DWORD (32-bit) Value 并将其命名为 developertools。
双击它以将数值(Value)数据设置为 1 ,然后单击 确定 (OK )按钮。
最后,重新启动计算机以获取更改。
注意: (Note: )您需要 下载 Office 的组策略模板 才能使用文章中提到的GPEDIT方法。(GPEDIT)另一个重要的事情是,虽然它说 Microsoft Excel16或 Microsoft Word 16 ,但您也可以在(Microsoft Word 16)Microsoft 365或Office 2021/19程序上应用相同的设置。
希望这可以帮助。
How to add Developer tab in Word and Excel Office programs
Adνanced users of Microsoft Office will want to have the Developer tab showcased on the Ribbon of Word or Excel programs at all times. However, that tab is not shown by default, which means it can be manually added. Doing this is pretty simple, but not everyone might know how to do it. You can use the Program’s settings, Group Policy or the Registry Editor to do this.
With this in mind, we have decided to explain how to add the Developer Tab to the Ribbon area in Microsoft Office.
What is the Developer Tab used for?
- Run XML commands: One of the cool features of Microsoft Office is the ability to run XML commands. Advanced users and businesses primarily use these commands.
- Develop applications to run in Microsoft Office tools: Yes, it is possible to create your application to run in Microsoft Office for your own needs.
- Write and run Macros: Microsoft has made it possible for users to write and run macros in its Office suite for the longest time. Macros are powerful, and as such, they can be dangerous since running a Macro is similar to running a line of code. You see, Macros have been used to install malware and other dangerous viruses on Windows for a long time now, and despite improved security measures from Microsoft, Macros are still a threat if used in the wrong way.
- Use ActiveX controls: Internet Explorer has its own plug-in system called ActiveX Controls, which can also be used in Microsoft Office via the Developer Tab. If you know what you are doing, then go on ahead and make use of ActiveX in your Office document. However, if you are new to this, we suggest only installing ActiveX tools from a trusted source. Similar to Macros, we understand that ActiveX can be a source for installing malicious software on your computer.
How to add Developer tab in Office programs
OK, so once the Developer Tab is added to the Word or Excel Ribbon, it will stay visible until manually removed. The process is simple:
- Launch Word or Excel
- Open the Options menu
- Open Customize Ribbon
- Activate Developer
Let us talk about this issue in a more detailed manner.
1] Open the Options menu
The first step into adding the Developer Tab to Microsoft Office programs is to click on File, then navigate to Options. You should see several choices, but only one on the list is essential in this respect.
2] Open Customize Ribbon
We have spoken about this section before. You see, if something is missing from the Ribbon in Microsoft Office, then chances are, this is where you will find it. The same goes if you want to remove a feature from the Ribbon.
3] Activate Developer
After you have selected Customize Ribbon, you should see two sections. One on the left is called Popular Commands, and another on the right is called Main Tabs. You will want to look under Main Tabs for Developer and be sure to click inside of the empty box.
Finally, click the OK button, and right away, the Developer Tab should appear on the Ribbon.
How to add Developer tab in Word using Group Policy
To add Developer tab in Word using Group Policy, follow these steps:
- Press Win+R to open the Run prompt.
- Type gpedit.msc and press the Enter button.
- Navigate to Customize Ribbon in User Configuration.
- Double-click on the Display Developer tab in the Ribbon setting.
- Choose the Enabled option.
- Click the OK button.
To learn more about these steps, continue reading.
To get started, press Win+R to open the Run prompt, type gpedit.msc, and hit the Enter button. Then, navigate to this path:
User Configuration > Administrative Templates > Microsoft Word 2016 > Word Options > Customize Ribbon
Here you can see a setting called the Display Developer tab in the Ribbon. You need to double-click on it and select the Enabled option.
Then, click the OK button to save the change.
How to add Developer tab in Word using Registry
To add Developer tab in Word using Registry, follow these steps:
- Press Win+R to show the Run prompt.
- Type regedit > press the Enter button > click the Yes button.
- Navigate to Microsoft in HKCU.
- Right-click on Microsoft > New > Key and name it as office.
- Right-click on office > New > Key and name it as 0.
- Right-click on 0 > New > Key and set the name as word.
- Right-click on word > New > Key and name it as options.
- Right-click options > New > DWORD (32-bit) Value.
- Name it as developertools.
- Double-click on it to set the Value data as 1.
- Click the OK button and restart your computer.
Let’s check out these steps in detail.
First, press Win+R, type regedit, and press the Enter button. Then, click the Yes option in the UAC prompt. Next, navigate to the following path:
HKEY_CURRENT_USER\Software\Policies\Microsoft
Right-click on Microsoft > New > Key, and name it as office.
Then, follow the same method to create a sub-key under the office key and name it as 16.0. Repeat the same steps to create a sub-key under the 16.0 key and call it word.
Right-click on word > New > Key and name it as options. Following that, right-click on options > New > DWORD (32-bit) Value and set the name as developertools.
Once done, double-click on it to set the Value data as 1.
Click the OK button and restart your computer.
How to add Developer tab in Excel using Group Policy
To add Developer tab in Excel using Group Policy, follow these steps:
- Search for gpedit.msc in the Taskbar search box.
- Click on the individual search result.
- Navigate to Customize Ribbon in User Configuration.
- Double-click on the Display Developer tab in the Ribbon setting.
- Choose the Enabled option.
- Click the OK button.
Let’s delve into these steps in detail.
First, you need to open the Local Group Policy Editor. For that, search for gpedit.msc in the Taskbar search box and click on the individual search result.
Once it is opened, navigate to the following path:
User Configuration > Administrative Templates > Microsoft Excel 2016 > Word Options > Customize Ribbon
Double-click on the Display Developer tab in the Ribbon setting and choose the Enabled option.
Click the Apply and OK buttons to save the change and restart Excel to find the Developer tab.
How to add Developer tab in Excel using Registry
To add Developer tab in Excel using Registry, follow these steps:
- Search for regedit in the Taskbar search box.
- Click on the individual search result and click the Yes button.
- Navigate to Microsoft in HKCU.
- Right-click on empty space > New > Key and set the name as office.
- Repeat these steps to create a sub-key and name it 0.
- Right-click on 0 > New > Key and set the name as excel.
- Right-click on excel > New > Key and name it as options.
- Right-click on options > New > DWORD (32-bit) Value.
- Name it as developertools.
- Double-click on it to set the Value data as 1 and click the OK button.
- Reboot your PC.
To know more about these above-mentioned steps in detail, continue reading.
First, you need to open the Registry Editor. For that, search for regedit in the Taskbar search box, click on the individual search result and click the Yes option.
Then, navigate to the following path:
HKEY_CURRENT_USER\Software\Policies\Microsoft
If you have already set this setting for other Office programs, you may find the office sub-key under the Microsoft key. In that case, you need to skip to the 6th step. Otherwise, you need to create all the sub-keys manually for Excel. To do that, right-click on Microsoft > New > Key and name it as office.
Then, repeat these steps to create a sub-key under office and name it as 16.0. Do that again to create a sub-key under 16.0 and name it as excel. One last time, repeat these steps to create another sub-key and name it as options.
Once done, you need to create a REG_DWORD value. For that, right-click on options > New > DWORD (32-bit) Value and name it as developertools.
Double-click on it to set the Value data as 1 and click the OK button.
Finally, reboot your computer to get the change.
Note: You need to download the Group Policy template for Office in order to use the GPEDIT method mentioned in the article. Another important thing is that although it says Microsoft Excel16 or Microsoft Word 16, you can apply the same settings on Microsoft 365 or Office 2021/19 programs as well.
Hope this helps.