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.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop and more.