How to insert developer tab in excel

To enable developer tab in Excel for Microsoft 365, you can select the File tab, then select Options => Customize Ribbon.

For Excel 2007: Click on the Office button, then click on Excel Options => Customize Ribbon.

For Excel 2010 and later versions: Click on the File tab or the Office button, then click on Options => Customize Ribbon.

In the Excel Options dialog box, click on Customize Ribbon on the left-hand side.

In the right-hand panel, under Main Tabs

Look for the Developer checkbox in the list of tabs on the right.

Check the box next to Developer.

Once you've checked the Developer tab checkbox, click OK at the bottom of the Excel Options dialog box.

Now, look at the ribbon in Excel. You should see a new tab labeled Developer.