Microsoft Excel logo on a green background

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

What Does the Developer Tab Do in Excel?

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

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

RELATED: How to Add the Developer Tab to the Microsoft Office Ribbon

Enable Excel’s Developer Tab

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

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

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

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 “Customize the Ribbon” column, from the “Main Tabs” section, enable the “Developer” option. Then click “OK” at the bottom.

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

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

The "Developer" tab in Excel.


RELATED: How to Create a Basic Form in Microsoft Excel

Profile Photo for Mahesh Makvana Mahesh Makvana
Mahesh Makvana is a freelance tech writer who specializes in writing how-to guides. He has been writing tech tutorials for over a decade now. He’s written for some of the prominent tech sites including MakeUseOf, MakeTechEasier, and Online Tech Tips.
Read Full Bio »