EXCEL - How to Enable the Developer tab

In this article I am going to explain how to enable the Developer Tab in the Excel Sheet. By default the Developer tab is not enabled in the Excel sheet. Please find the below steps to enable to Developer Tab in the Excel Sheet.

STEPS:

1) From the File --> Go to Options --> Click Options.
2) In the Excel Options Popup click the Customize the Ribbon.
3) In the Customize the Ribbon section, Main Tab section Click the Developer check box and Click OK button.
4) Now the Developer option is enabled. Please find the screen shot below.

For Office 2007
From file menu - Excel Options - Popular - Check the box Show the developer tab in the Ribbion option
Please find the screen shot below