How to Enable Developer Tab in Excel

Excel macro is the way to automate / develop advanced tools in excel. To have this feature you have to enable developer tab first. It is is showing that VBA controls for the excel sheet. You can add, delete  or modify macros through Developer tab. Further the method/process to enable developer tab is based on the excel version you are using.  Therefore please make sure to follow correct method according to your excel version.

Enable Developer Tab in Excel 97-2003

There is no Ribbon on the excel 97-2003 version. That means no tabs in that version. Therefore we can't enable/disable a tab named developer in excel 97-2003. Instead we can activate the Vba editor window using below method.

1. Go to Tools menu
2. Then select Macro.
3. You can find the Visual Basic Editor Command There. Click on it to open VBA Editor.
4. Alternatively You can pre Alt + F11

Enable Developer Tab in Excel 2007

1. Click the "Microsoft Button" on left side upper corner.
2. Then select the "Excel Options"
3. Then click "Popular"
4. After that select the "Show Developer Tab in the Ribbon".

Enable Developer Tab in Excel 2010 & Later

1. Click the "File" Command
2. Then select "Options" button.
3. Then Choose "Customize Ribbon" from the new dialog box.
4. After that select "Developer Tab" check box from the list of "Main Tabs"
5. Finally Click "OK".