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.

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

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

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.

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

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.