The Developer tab isn't displayed by default, but you can add it to the ribbon. On the File tab, go to Options > Customize Ribbon. Under Customize the Ribbon and under Main Tabs, select the Developer check box.
How do I add the Developer tab in Excel 2020?
This is what you need to do:
- Right-click anywhere on the ribbon and choose Customize the Ribbon… in the pop-up menu of options:
- The Excel Options dialog window will show up with the Customize Ribbon option on the left selected.
- Under the list of Main Tabs on the right, select the Developer check box and click OK.
Does all Excel have Developer tab?
The Developer tab is a feature included in Microsoft Excel, and it is usually hidden by default.