How to Add the Developer Tab in Microsoft Excel for Office 365

The tabs at the top of the window in Microsoft Excel provide you with the means to format and create many of the objects that you will need when editing your spreadsheet. But that ribbon isn’t set in stone, and you are able to remove or add certain tabs from it as needed.

One tab that you might find you need is the Developer tab, this one includes some important features, such as the ability to create macros. Our guide below will show you how to add the Developer tab to the ribbon in Excel for Office 365.

Why Doesn’t Excel for Office 365 Have a Developer Tab?

This tab is typically hidden by default, because many users don’t need the features that it provides, and using those features can can be complicated. But the tools on the Developer tab can allow for some very useful additions to a spreadsheet, so continue below to see how to add it.

Step 1: Open Excel for Office 365.

Step 2: Click the File tab at the top-left of the window.

click the File tab

Step 3: Click the Options button at the bottom of the left column.

click the Options button

Step 4: Select the Customize Ribbon tab from the left side of the Excel Options window.

choose the Customize Ribbon tab

Step 5: Check the box to the left of Developer from the list at the right side of the window. You can then click the OK button to apply your changes.

how to add the Developer tab in Excel for Office 365

You should now see the Developer tab at the top of the window.

Developer tab in Excel for Office 365

Working on a spreadsheet that doesn’t have any column letters or row numbers? Find out how to restore the headings to view and make your file navigation a little simpler.