How to show the Developer Menu/Tab in Microsoft Excel 2010

Printer-friendly versionPrinter-friendly versionSend by emailSend by emailPDF versionPDF version

When you install MS Excel for the first time, the default setting has the Developer tab "disabled". This means that the Macro button not available including all VBA programming aspect of the Excel file.

Excel 2010 Main Tabs

To enable the Developer Tab, here are the steps:

Step 1: Open MS Excel 2010

Step 2: Click on File menu

Step 3: Click on Options

Excel 2010 Options

Step 4: In the Excel Options dialog box, click on Customize Ribbon in the left panel

Step 5: In the Customize Ribbon group, select Main Tabs

Excel 2010 Customize Ribbon

Step 6: Click on the the "Developer" item to put a check on it to "enable" the Developer tab

Step 7: Click OK button to close the dialog box

Step 8: Now, the Developer tab shall appear as the last item in the Main tabs

Excel 2010 Developer Tab shown

MS Office Software: