Hold down and click the first and last sheet tabs to create a contiguous group (Figure A). On the right, within the Main Tabs pane, check the Developer option.It will show the Customize the Ribbon options on the right. In the Excel Options dialogue box, click on Customize Ribbon in the left pane.Click Save and then close Excel Preferences. Under Customize the Ribbon, select Main Tabs and then check Developer. Select Excel > Preferences > Ribbon & Toolbar. Select the Developer check box under Main Tabs on the right, and then click OK.Click Customize Ribbon in the left pane.
To do this, follow these steps: Click the Microsoft Office Button, and then click Excel Options. The tab allows users to create VBA applications, design forms, create macros, import and export XML data, etc. The Developer tab is a feature included in Microsoft Excel, and it is usually hidden by default. Under the list of Main Tabs on the right, select the Developer check box and click OK.The Excel Options dialog window will show up with the Customize Ribbon option on the left selected.Right-click anywhere on the ribbon and choose Customize the Ribbon… in the pop-up menu of options:.How do I add the Developer tab in Excel 2020? 19 How do I add the Developer tab in Word 2007?.16 Why don’t I have a design tab in Excel?.15 How do I enable the Developer tab in Excel 2010?.14 Where is the Developer tab in Word for Mac?.13 Where is the Tools menu in Excel 2020?.12 Why is there no File tab in Excel on Mac?.11 How do I use developer in Excel 2016?.10 Where is Quick Access toolbar in Excel?.9 How do I create a macro tab in Excel?.8 How do I view the macro tab in Excel?.7 How do I get the Developer tab in Excel 2007?.6 How do you add a tab in an Excel tab?.3 How do I use developer tools in Excel?.1 How do I add the Developer tab in Excel 2020?.