How to add the Developer tab to Microsoft Excel

How to add the Developer tab to Microsoft Excel

Microsoft Excel has hidden many features in its Developer tab, which is available on both Windows and Mac. This tab is not visible by default, but you can turn on an option to make it visible. We will show you how.

What does the Developer tab do in Excel?

The Developer tab of Excel contains many options that you can use with your spreadsheets. These options include:

  • Create macro
  • Run existing macros
  • Use XML commands
  • Use ActiveX controls
  • Create apps that you can use with Excel
  • Add form controls
  • Use ShapeSheet in Microsoft Visio
  • Create new shapes and stencils in Microsoft Visio

The Developer tab is available in all Office programs, including Excel, Word, and PowerPoint. Check out the tab in these apps to access more features.

Enable the Excel Developer tab

To show the Developer tab in Excel, first open Microsoft Excel on your Windows or Mac computer.

If you are in the Excel screen where your templates are shown, then from the left sidebar select “Options”. If you are on the Excel editing screen, select File> More> Options instead.

Click "Options" in Excel

You will see an “Excel Options” window. In the left sidebar of this window, click “Customize Ribbon”.

Click "Customize Ribbon" in the "Excel Options" window.

In the “Customize the Ribbon” pane on the right, click the “Customize the Ribbon” drop-down menu and select “Main Tabs”.

Choose "Main Tabs" from the "Customize the Ribbon" drop-down menu.

In the same column “Customize the ribbon”, from the “Main tabs” section, enable the “Developer” option. Then click “OK” at the bottom.

Enable "Developer" in the "Main Tabs" section.

Returning to the Excel window, at the top, you will now see a new tab called “Developer”. Click on the tab to see all the options it offers.

The "Developer" tab in Excel.

Have a good time!

Similar Posts

Leave a Reply

Your email address will not be published.